oracle表空间的使用率,Oracle 查看表空间使用率

1. 查看数据库所以表空间文件；

select * from dba_data_files;

2. 查看所以表空间的总容量：

select dba.TABLESPACE_NAME, sum(bytes)/1024/1024 as MB  from dba_data_files dba group by dba.TABLESPACE_NAME;

3.. 查看数据库表空间使用率

select total.tablespace_name,     round(total.MB, 2) as Total_MB,     round(total.MB - free.MB, 2) as Used_MB,     round((1-free.MB / total.MB)* 100, 2) || '%' as Used_Pct from     (select tablespace_name, sum(bytes) /1024/1024 as MB from dba_free_space group by tablespace_name) free,     (select tablespace_name, sum(bytes) / 1024 / 1024 as MB from dba_data_files group by tablespace_name) total     where free.tablespace_name = total.tablespace_name order by used_pct desc;