Calculate Oracle Table Size

To calculate the size of data in an Oracle table, you can use the following methods:

Utilize the dba_segments view provided by Oracle to query the space occupied by a table. For example, executing the following SQL statement can show the space occupied by a specified table:

SELECT segment_name, segment_type, bytes/1024/1024 AS size_mb
FROM dba_segments
WHERE segment_name = 'YOUR_TABLE_NAME';

This will return the name, type, and size of the table in MB.

2. Use the dba_extents view to query the table’s extension size, which includes all extensions of the table. For example, you can view the extension size of a specific table by executing the following SQL statement:

SELECT segment_name, segment_type, SUM(bytes)/1024/1024 AS size_mb
FROM dba_extents
WHERE segment_name = 'YOUR_TABLE_NAME'
GROUP BY segment_name, segment_type;

This will return the table’s name, type, and the total storage size in MB.

3. Use the dba_tables view to query the number of rows in a table. For example, running the following SQL statement can show the number of rows in a specific table:

SELECT num_rows
FROM dba_tables
WHERE table_name = 'YOUR_TABLE_NAME';

This will return the number of rows in the table.

Please note that the YOUR_TABLE_NAME in the above methods should be replaced with the name of the table you want to analyze.