Custom Search
www.rocket99.com : Technical Guides Sybase Oracle UNIX Javascript


Technical Guides
Sybase
Oracle
UNIX
Javascript




Of Interest

Business Intelligence and Analytics



Oracle Training





Oracle » Monitoring » Performance »

Determining Cache Hit Percentages

     




Showing the current cache hit percentage data in Oracle.






select
(1 -
(select value from v$sysstat where name = 'physical reads') /
( (select value from v$sysstat where name = 'db block gets') +
(select value from v$sysstat where name = 'consistent gets') )
)*100
as "CacheHitPct"
from dual
;


column value format 999999999999.99999

select name, value from v$sysstat
where name like '%cache%'
order by 1
;










Oracle : Related Topics

Oracle : Monitoring : Displaying Running SQL Commands and Wait Times

Sybase Web Site
Sybase iAnywhere Mobile Web Site
Oracle Enterprise Web Site



Get the latest Rocket99 news and tech tips via






Site Index About this Guide to Sybase, Oracle, and UNIX Contact Us Advertise on this site




Copyright © 2016 Stoltenbar Inc All Rights Reserved.