RE: Operations that perform multiblock I/O and cluster factor
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: Riku Räsänen <riku.rasanen@xxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 10 Dec 2007 13:39:58 -0700
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@xxxxxxxxxxxxxxxx]
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
