Jul 31 2011

Learn Free Space of Tablespaces in Oracle

Category: Administration,SQLFatih Acar @ 07:23

You can learn allocate area of tablespaces. You can use data dictionary for this processing.

SELECT a.tablespace_name, a.file_name, a.bytes allocated_bytes,
b.free_bytes
FROM dba_data_files a,
(SELECT file_id, SUM(bytes) free_bytes
FROM dba_free_space b GROUP BY file_id) b
WHERE a.file_id=b.file_id
ORDER BY a.tablespace_name;

9,824 total views, 5 views today

Tags: Administration, Oracle, SQL

facebook comments:

Leave a Reply

Time limit is exhausted. Please reload CAPTCHA.