반응형
// 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 |