Tuesday 17 January 2017

How to find out if the statistics are locked for a specific table?

The query which might help is:

select owner, table_name, stattype_locked
from dba_tab_statistics
where stattype_locked is not null;