Content-Class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
Subject: RE: Operations that perform multiblock I/O and cluster factor
Date: Mon, 10 Dec 2007 13:39:58 -0700
Message-ID: <04DDF147ED3A0D42B48A48A18D574C450999D4D7@NT15.oneneck.corp>
In-Reply-To: <2509.62.142.244.186.1197317491.squirrel@webmail.ainaratkaisu.fi>
Thread-Topic: Operations that perform multiblock I/O and cluster factor
Priority: normal
References:    <578806DDE66A3A45916740EB73C6982AB42BB5D391@M1EXCHANGE01.mmi.local>    <04DDF147ED3A0D42B48A48A18D574C450999D439@NT15.oneneck.corp> <2509.62.142.244.186.1197317491.squirrel@webmail.ainaratkaisu.fi>
From: "Allen, Brandon" <Brandon.Allen@OneNeck.com>
To: =?iso-8859-1?Q?Riku_Räsänen?= <riku.rasanen@kantamestarit.fi>,
 <oracle-l@freelists.org>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: Brandon.Allen@OneNeck.com

Thanks, but without the trace file this is just hearsay.  Are you sure the db file scattered reads actually came from the index range scan?  They may have come from some other part of the query, or an entirely separate query, possibly a recursive query that you weren't even aware of.  You would have to verify that the db file scattered read wait events referenced the same cursor number AND the same session/serial number, and lookup the fileid and block number to verify they match the expected object before I'd be convinced.

Regards,
Brandon


-----Original Message-----
From: Riku Räsänen [mailto:riku.rasanen@kantamestarit.fi] 


Actually, I have seen "db file scattered read" on INDEX RANGE SCAN, and I had a 10046 trace file for that, but was unable to find it (I must have deleted it).

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

--
http://www.freelists.org/webpage/oracle-l