ORA-20005 : object statistics are locked


If you receive errors in the form of ORA-20005 and ORA-06512 during the collection of the table statistics, you must unlock the relevant table statistics.

When you run GATHER_TABLE_STATS, if it returns a result as follows you must unlock the statistics of the corresponding table.


Unlocking table statistics:

You can use the following command for this operation.

Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *