Of Interest
Be responsible for your future
Enter the USA legally!
Visa, Green Card, Citizenship, Passport
Consultation Services
|
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
;
|
|
|
Get the latest Rocket99 news and tech tips via
|
