查詢數(shù)據(jù)庫總?cè)萘浚咽褂萌萘浚Ｓ嗳萘?/p>

SELECT
ROUND(SUM(a.bytes) / 1024 / 1024 / 1024, 2) AS total_size_gb, -- 總大小（GB）
ROUND(SUM(a.bytes - NVL(f.bytes, 0)) / 1024 / 1024 / 1024, 2) AS used_size_gb, -- 已使用大小（GB）
ROUND(SUM(NVL(f.bytes, 0)) / 1024 / 1024 / 1024, 2) AS free_size_gb -- 剩余大小（GB）
FROM dba_data_files a
LEFT JOIN (SELECT file_id, SUM(bytes) AS bytes FROM dba_free_space GROUP BY file_id) f
ON a.file_id = f.file_id;

查詢表空間的詳細使用情況

SELECT

df.tablespace_name,

 df.total_mb,

nvl(fs.free_mb, 0) AS free_mb,

df.total_mb - nvl(fs.free_mb, 0) AS used_mb,

ROUND((df.total_mb - nvl(fs.free_mb, 0)) / df.total_mb * 100, 2) AS used_percent

FROM

(SELECT tablespace_name, ROUND(SUM(bytes) / 1024 / 1024, 2) AS total_mb

 FROM dba_data_files

GROUP BY tablespace_name) df

LEFT JOIN

 (SELECT tablespace_name, ROUND(SUM(bytes) / 1024 / 1024, 2) AS free_mb

 FROM dba_free_space

GROUP BY tablespace_name) fs

ON df.tablespace_name = fs.tablespace_name

ORDER BY df.tablespace_name;