How to find table where statistics are locked



Last updated on December 21st, 2015 at 06:17 am

You can use the below query on How to find table where statistics are locked

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

Now once we find out the objects,we can use below queries to unlock them
exec dbms_stats.unlock_schema_stats(‘schema_owner’);
exec dbms_stats.unlock_table_stats(‘table_owner’,’table_name’);


Leave a Reply