Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Does Gather_table_stats with Cascade option True lock table?

2680913Sep 8 2014 — edited Sep 9 2014

Hi all,

I've read many docs as well as topics on Oracle Community, but I can't make sure that DBMS_STATS.GATHER_%_STATS with Cascade option TRUE locks table or not (I mean prevent DML from executing). Cascade = TRUE will make DBMS_STATS gather index statistics too.

I did some test but sometimes the table was locked exclusive, and I couldn't update rows, sometimes the table was not locked and I could update. I was really crazy.

Please help me understand.

Thank you so much.

This post has been answered by Hemant K Chitale on Sep 8 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 7 2014

Added on Sep 8 2014

#general-database-discussions

2 comments

1,113 views