The biggest difference between "consistent gets"
in v$sysstat and v$buffer_pool is the fact that
the buffer pool stats don't include "consistent
gets - examinations", which are still latched
accesses to buffered blocks, and should therefore
arguably be counted.
--
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Next Seminars
UK Sept, Nov
USA x 2 November
http://www.jlcomp.demon.co.uk/seminar.html
Daud wrote in message ...
>Thanks! Found it in Steve Adam's website. It is caused by a
>long-standing Oracle bug that greatly overstates the number of
>consistent gets.
>
>rgds
>Daud
>
>srivenu_at_hotmail.com (srivenu) wrote in message
news:<1a68177.0208062022.69016228_at_posting.google.com>...
>> I dont remember where, but i had read somewhere(Jonathan lewis site ?)
>> that the V$SYSSTAT statictics on consistent gets is not exactly right.
Received on Fri Aug 09 2002 - 08:23:13 CDT
