메모리 활용률 쿼리

메모리 활용률 쿼리

 

select
-- Dictionary Hit ---------------------------------
(select to_char(trunc((1-sum(getmisses)/sum(gets))*100, 2))
       from   v$rowcache) "Dictionary Hit",
-- Blockbuffer Hit ---------------------------------
(SELECT to_char(trunc( (1 - (PHYSICAL_READS / (DB_BLOCK_GETS + CONSISTENT_GETS)))*100,2))
FROM V$BUFFER_POOL_STATISTICS) "Blockbuffer Hit",
-- Library Hit ---------------------------------
(select to_char(trunc((1-sum(reloads)/sum(pins))*100, 2)) from v$librarycache) "Library Hit",
-- Disk Sort ---------------------------------
(select  to_char(trunc(sum(waits)/sum(gets)*100,2)) "RBS Waits(%)"
from v$rollstat) "RBS contention",
(select
trunc("buffer busy waits"/("db block gets"+"consistent gets")*100,5)
from (
select
(select value from v$sysstat where name = 'consistent gets') "consistent gets",
(select value from v$sysstat where name = 'db block gets') "db block gets",
(select total_waits from v$system_event where event = 'buffer busy waits') "buffer busy waits"
from dual
)) "Buffer Busy Wait Ratio" from dual;