Re: db buffer cache

Sorry about the delay in replying to this one.

I haven't yet seen anything documenting this statistic, but when I was down in Australia with Steve Adams we kicked the idea around for a bit and came to a tentative conclusion that it was a consistent get where the CURRENT block was known to be the required block.

(Which means that slightly less work is done - even though the relevant cache buffers chains latch is still hit).

--
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




srivenu wrote in message <1a68177.0208092309.30252050_at_posting.google.com>...


>Thanks for the reply Jonathan

>What are consistent_gets examinations ?

>What is examined ?

>regards

>Srivenu