Sunday , March 3 2024

How To Calculate Actual Size of All Tables in a Schema in Oracle


When calculating the size of a table in an Oracle database, it is incorrect to just look at the data size. It is necessary to calculate the size of the index, lobsegment and lobindex objects of the table. Because when we move the table to another database, all objects belonging to the table will also be moved.

The following query can be used to calculate the actual size of all tables in a schema. You must write the user/schema name you want to calculate instead of the “YOUR_USER/SCHEMA_NAME” section in the query.


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 *