Re: DB Block Buffer Optimization in Version 6

In article <3pqm1u$qn8_at_Mercury.mcs.com>, amit_at_MCS.COM (Location) writes:
::From: amit_at_MCS.COM (Location)
::Newsgroups: comp.databases.oracle
::Subject: DB Block Buffer Optimization in Version 6
::
::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))/
:: (sum(decode(name,'db block gets',value,0)) +
:: (sum(decode(name,'consistent gets',value,0))))) "Read Hit Ratio"
::from v$sysstat;
::How does one go about getting this information in version 6?
::

 Same theory in V6 only v$sysstat has a code not a name against it.

 For the names look in v$statname.   

-- 
+--------------------------+-------------------------+-----------------------+
| Ian Bainbridge           | bainbridge.i_at_bgers.co.uk|Phone: (44)191-216-0202|
| British Gas ERS          | Newcastle Upon Tyne, UK |            x2790      |
+--------------------------+-------------------------+-----------------------+