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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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,068 views