Oracle Table Size Query: Check Each Table’s Space

1 year ago
Jackson Davis
1 minute

You can use the following SQL statement to query the size of each table in an Oracle database:

SELECT owner, table_name, round((blocks * 8 / 1024), 2) AS "Size(MB)"
FROM dba_tables
WHERE owner NOT IN ('SYS', 'SYSTEM')
ORDER BY 3 DESC;

This query will fetch the owner, table name, and size (in MB) of tables from the dba_tables view. The condition owner NOT IN (‘SYS’, ‘SYSTEM’) is used to exclude system tables.

Please note that you need to have the query permission for the dba_tables view in order to execute this query.

bannerAds