Oracle常用语句－－统计每个表空间的使用信息
SELECT a.tablespace_name , a.bytes bytes_used , b.largest , round(((a.bytes – b.bytes) / a.bytes) * 100,2) percent_used FROM
(SELECT tablespace_name,sum(bytes) bytes FROM dba_data_files GROUP BY tablespace_name) a,
(SELECT tablespace_name,sum(bytes) bytes,max(bytes) largest FROM dba_free_space GROUP BY taboracle账号lespace_name) b WHERE a.tablespace_name = b.tablespace_name
ORDER BY ((a.bytes-b.bytes)/a.bytes) DESC
www.2cto.com