Skip to Main Content

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!

what does all mean for dba_tab_statistics.STATTYPE_LOCKED???

George MendoncaMar 5 2015 — edited Mar 6 2015

I'm trying to check the status of the all the table stats for a schema.  When I query dba_tab_statistics.stattype_locked I see it says all for most of the tables.  In the docs it only says it can be one of 3 different outputs, data, cache or all.  I would have expected this to be a yes or no type answer.  Not finding any docs to explain what these mean.  Anyone have any ideas?

This post has been answered by BPeaslandDBA on Mar 5 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 3 2015
Added on Mar 5 2015
4 comments
6,129 views