How can you check the remaining size of an Oracle table…

1 year ago
Emily Johnson
1 minute

To check the remaining size of tablespace in an Oracle database, you can use the following SQL statement:

SELECT tablespace_name, sum(bytes)/1024/1024 AS size_in_mb, sum(maxbytes)/1024/1024 AS max_size_in_mb, sum(bytes)/1024/1024 - sum(bytes)/1024/1024 AS free_size_in_mb
FROM dba_data_files
GROUP BY tablespace_name;

This query will return the name of each tablespace, the current size being used, the maximum available size, and the remaining size (in MB).

bannerAds