Oracle 中对表空间使用情况进行查询
1 --1G=1024MB 2 --1M=1024KB 3 --1K=1024Bytes 4 --1M=11048576Bytes 5 --1G=1024*11048576Bytes=11313741824Bytes 6 SELECT a.tablespace_name "表空间名", 7 total "表空间大小", 8 free "表空间剩余大小", 9 (total - free) "表空间使用大小", 10 total / (1024 * 1024 * 1024) "表空间大小(G)", 11 free / (1024 * 1024 * 1024) "表空间剩余大小(G)", 12 (total - free) / (1024 * 1024 * 1024) "表空间使用大小(G)", 13 round((total - free) / total, 4) * 100 "使用率 %" 14 FROM (SELECT tablespace_name, SUM(bytes) free 15 FROM dba_free_space 16 GROUP BY tablespace_name) a, 17 (SELECT tablespace_name, SUM(bytes) total 18 FROM dba_data_files 19 GROUP BY tablespace_name) b 20 WHERE a.tablespace_name = b.tablespace_name