Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!prodigy.com!in.100proofnews.com!in.100proofnews.com!nntp-relay.ihug.net!ihug.co.nz!nntp.cs.ubc.ca!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: mccmx@hotmail.com (Matt)
Newsgroups: comp.databases.oracle.server
Subject: Re: Oracle Brain Teaser
Date: 8 Aug 2003 01:52:14 -0700
Organization: http://groups.google.com/
Lines: 13
Message-ID: <cfee5bcf.0308080052.38c3a79f@posting.google.com>
References: <cfee5bcf.0308070051.3b923a6e@posting.google.com> <3F326DC6.23594AEC@remove_spam.peasland.com>
NNTP-Posting-Host: 212.137.63.38
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1060332735 20891 127.0.0.1 (8 Aug 2003 08:52:15 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 8 Aug 2003 08:52:15 GMT
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:240080

Thanks for the feedback guys..

I am aware of the danger of concentrating on hit ratios and PIOs.  I
just needed confirmation about how a statement managed to hit the
buffer cache so many times without ageing blocks out and re-reading
them in.

From what you are saying, the statement is in a tight loop,
continually re-reading the same blocks.

Thanks again.

Matt