Hi all,
I ran the below query on my database and I got:
WITH dB_CACHE_SIZE =712M IS IT STILL TOO SMALL???Code:select a.value + b.value "logical_reads", c.value "phys_reads", round(100 * ((a.value+b.value)-c.value) / (a.value+b.value)) "BUFFER HIT RATIO" from v$sysstat a, v$sysstat b, v$sysstat c where a.statistic# = 38 and b.statistic# = 39 and c.statistic# = 40;
logical_reads phys_reads BUFFER HIT RATIO
8982109 39133012 -336
just want to confirm with you guys




Reply With Quote