Showing posts with label ORA-20005: object statistics are locked; dbms_stats; gather_table_stats; lock_table_stats; unlock_table_stats. Show all posts
Showing posts with label ORA-20005: object statistics are locked; dbms_stats; gather_table_stats; lock_table_stats; unlock_table_stats. Show all posts

Monday, October 26, 2015

ORA-20005: object statistics are locked

Error “ORA-20005: object statistics are locked” means that table statistics are locked and hence stats can’t be gathered on this table. Stats are locked if we don’t want stats to be gathered on some or all of our tables.

Following example explains stats locking and unlocking process.

Popular Posts - All Times