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.

dbtut
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 *