查看Oracle表空间的使用率

oracle 2010-12-18

sqlplus / as sysdba

>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;

TABLESPACE   TOTAL_MB    USED_MB   USED_PCT

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

UNDOTBS1          805      33.31       4.14  

SYSAUX            340     331.56      97.52

BLOBS            1000     194.38      19.44

USERS            6984    6916.31      99.03

SYSTEM            360     355.25      98.68

INDX             1500     428.44      28.56

WCAUDIT           500        .06        .01

相关推荐