top of page
SGA Hit Ratios
Data Dictionary
SELECT Parameter,SUM(getmisses), SUM(gets)
FROM v$rowcache group by parameter
Buffer Cache
SELECT name,value from v$sysstat where
name in
('db block gets',
'consistent gets',
'physical reads')
Library Cache
select
namespace,
gets,
gethitratio*100 gethitratio,
pins,
pinhitratio*100 pinhitratio,
reloads,
invalidations
from
v$librarycache
Download Speedway to graphically plot the above script results.
![](https://static.wixstatic.com/media/7ded0a_156fd53a976e4255b4152ba22e668718~mv2.jpg/v1/fill/w_600,h_392,al_c,q_80,usm_0.66_1.00_0.01,enc_auto/7ded0a_156fd53a976e4255b4152ba22e668718~mv2.jpg)
Complete Database Performance Management
bottom of page