sql脚本代码

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;