Oracle数据库日常检查 select a.tablespace_name tnm,a.bytes/1024/1024 total,c.bytes/1024/1024 free,
trunc((a.bytes-c.bytes)*100/a.bytes,0) "% USED",trunc((c.bytes*100)/a.bytes,0) "% FREE"
from SYS.SM$TS_AVAIL A,SYS.SM$TS_FREE C
WHERE A.TABLESPACE_NAME=C.TABLESPACE_NAME
AND A.TABLESPACE_NAME IN (select distinct tablespace_name from dba_tablespaces)
and trunc((a.bytes-c.bytes)*100/a.bytes,0) >=80
order by 4 desc;
