oralce 查询表空间使用情况

select a.tablespace_name "tablespace_name", 

total "allspace", 

free "freespace", 

(total - free) "usedspace", 

total / (1024 * 1024 * 1024) "space(G)", 

free / (1024 * 1024 * 1024) "freespace(G)", 

(total - free) / (1024 * 1024 * 1024) "usedspace(G)", 

round((total - free) / total, 4) * 100 "used%" 

FROM (SELECT tablespace_name, SUM(bytes) free 

FROM dba_free_space 

GROUP BY tablespace_name) a, 

(SELECT tablespace_name, SUM(bytes) total 

FROM dba_data_files 

GROUP BY tablespace_name) b 

WHERE a.tablespace_name = b.tablespace_name;

--------------------------------------------------------------

SELECT a.tablespace_name "表空间名", 

total "表空间大小", 

free "表空间剩余大小", 

(total - free) "表空间使用大小", 

total / (1024 * 1024 * 1024) "表空间大小(G)", 

free / (1024 * 1024 * 1024) "表空间剩余大小(G)", 

(total - free) / (1024 * 1024 * 1024) "表空间使用大小(G)", 

round((total - free) / total, 4) * 100 "使用率 %" 

FROM (SELECT tablespace_name, SUM(bytes) free 

FROM dba_free_space 

GROUP BY tablespace_name) a, 

(SELECT tablespace_name, SUM(bytes) total 

FROM dba_data_files 

GROUP BY tablespace_name) b 

WHERE a.tablespace_name = b.tablespace_name; 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/31123655/viewspace-2089189/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/31123655/viewspace-2089189/