Oracle DBA and beyond; these are practical tips for day to day DBA operation and maintenance; a place where you would come to look for a quick fix for a burning situation. I hope that by sharing all these, we all will become better in what we do. And on the way, I hope to save you some sweat :-)
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;
No comments:
Post a Comment