DB Block Buffer Optimization in Version 6
From: Location <amit_at_MCS.COM>
Date: 1995/05/22
Message-ID: <3pqm1u$qn8_at_Mercury.mcs.com>#1/1
Date: 1995/05/22
Message-ID: <3pqm1u$qn8_at_Mercury.mcs.com>#1/1
One way to analyze that the data block buffers are utilized optimally, in
version 7 is to measure the read hit ratio.
The sql for that in version 7 would be:
select 1 - (sum(decode(name,'physical reads',value,0))/
from v$sysstat;
How does one go about getting this information in version 6?
Received on Mon May 22 1995 - 00:00:00 CEST
(sum(decode(name,'db block gets',value,0)) +
(sum(decode(name,'consistent gets',value,0))))) "Read Hit Ratio"