datafile & tablespace 정보 확인

// Datafile info

SELECT name , phyrds as "FILE Read ", PHYBLKRD as "Read Block ",

phyrds * 100 / srw.phys_reads read_pct,  phywrts as "FILE Write ",

              PHYBLKWRT as "Write Block ", phywrts * 100 / srw.phys_wrts write_pct

FROM (SELECT SUM(phyrds) phys_reads, sum(phywrts) phys_wrts

 FROM V$FILESTAT) srw, v$datafile df, v$filestat fs  WHERE df.file# = fs.file#

ORDER BY (phywrts+phyrds) desc;

// Tablespace info

SELECT a.tablespace_name, a.bytes/1024/1024 "AMOUNT(MB)", b.bytes/1024/1024 "USED(MB)", c.bytes/1024/1024 "FREE(MB)",

(b.bytes*100)/a.bytes "% USED", (c.bytes*100)/a.bytes "% FREE"

FROM sys.sm$ts_avail a, sys.sm$ts_used b, sys.sm$ts_free c

WHERE a.tablespace_name=b.tablespace_name

AND a.tablespace_name=c.tablespace_name;