After Work
The best club in Chicago
for Chicago Singles is
Highlife Adventures!
Kyoto Sushi
in Chicago, on Lincoln Ave.
Moody's Pub
in Chicago, has great burgers
Skylark
in Chicago, on Halsted .. excellent beer selection!
|
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
;
|
|
|
|
