Check Oracle Table Size

1 year ago
Sophia Anderson
1 minute

To check the size of data in a table, you can use the following SQL query:

SELECT
    SUM(bytes)/1024/1024 AS "Size (MB)"
FROM
    dba_segments
WHERE
    segment_name = 'YOUR_TABLE_NAME';

Please replace YOUR_TABLE_NAME with the name of the table you want to query. This SQL statement will return the space occupied by the table in MB.

bannerAds