How To Check If There Is a Dictionary-Managed Tablespace On Oracle Database(Extent Management Control)


Extent Management Control can be LOCAL or Dictionary Based.

If local, the information in the bitmaps in the datafile is used.

If Dictionary Based, empty extents are queried in FET$ and UET$ views in the data dictionary.

Dictionary Based causes performance loss. It has become local default at 9i.

We use the following script to check for tablespaces that are not set to LOCAL.


We can change it as follows.

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 *