본문 바로가기

broko Blog!

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;



'broko Blog!' 카테고리의 다른 글

팁 모음  (1) 2016.02.18
락걸린 세션 Kill  (0) 2016.02.18
테이블 스페이스 삭제  (0) 2016.02.18
UNDO tablespace 관리  (0) 2016.02.18
사용자 비밀번호 초기화  (0) 2016.02.18