4、oracle查看表空间使用情况

oracle查看表空间使用情况

查看表空间大小、使用率、剩余空间

select   a.tablespace_name, total, free, total-free as used, substr(free/total * 100, 1, 5) as "FREE%", substr((total - free)/total * 100, 1, 5) as "USED%" from   (select tablespace_name, sum(bytes)/1024/1024 as total from dba_data_files group by tablespace_name) a,   (select tablespace_name, sum(bytes)/1024/1024 as free from dba_free_space group by tablespace_name) b where a.tablespace_name = b.tablespace_name order by a.tablespace_name ;