Wednesday , May 29 2024

There is a slowness problem when you query dba_free_space or tablespace in 12c


There may be a slowdown when you query dba_free_space or tablespaces via Toad on 12C databases. The slowness is due to the fact that the sys schema, data dictionary and fixed object statistics are out of date. In addition, the presence of too many objects in the recyclebin can cause slowdown. In this case, the statistics should be updated and the objects in the recyclebin should be cleared.

You can update the statistics as below:

You can delete objects within the recyclebin as follows at database basis:


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