RE: "direct path read" and "db file sequential read" used for full table scans in 11g
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: Sayan Malakshinov <xt.and.r@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 30 Aug 2012 21:40:48 +0000
Yes Sayan, very interested and already read them, but unfortunately I didn't
find anything to answer my questions there. If you see something I overlooked,
please excuse my ignorance and point me in the right direction.
Thanks
-----Original Message-----
From: Sayan Malakshinov [mailto:xt.and.r@xxxxxxxxx]
Hi, Brandon.
You may be interested in these articles:
http://hoopercharles.wordpress.com/2010/06/17/_small_table_threshold-parameter-and-buffer-cache-what-is-wrong-with-this-quote/
http://afatkulin.blogspot.com/2012/07/serial-direct-path-reads-in-11gr2-and.html
________________________________
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:
- » "direct path read" and "db file sequential read" used for full table scans in 11g- Allen, Brandon
- » RE: "direct path read" and "db file sequential read" used for full table scans in 11g- Allen, Brandon
- » Re: "direct path read" and "db file sequential read" used for full table scans in 11g- Sayan Malakshinov
- » RE: "direct path read" and "db file sequential read" used for full table scans in 11g - Allen, Brandon
- » RE: "direct path read" and "db file sequential read" used for full table scans in 11g- Allen, Brandon
- » Re: "direct path read" and "db file sequential read" used for full table scans in 11g- Sayan Malakshinov
- » Re: "direct path read" and "db file sequential read" used for full table scans in 11g- Tanel Poder
- » RE: "direct path read" and "db file sequential read" used for full table scans in 11g- Allen, Brandon
- » Re: "direct path read" and "db file sequential read" used for full table scans in 11g- Alex Fatkulin
- » RE: "direct path read" and "db file sequential read" used for full table scans in 11g- Allen, Brandon
- » RE: "direct path read" and "db file sequential read" used for full table scans in 11g- Allen, Brandon
- » Re: "direct path read" and "db file sequential read" used for full table scans in 11g- Alex Fatkulin
- » RE: "direct path read" and "db file sequential read" used for full table scans in 11g- Mark W. Farnham
- » Re: "direct path read" and "db file sequential read" used for full table scans in 11g- Kellyn Pot'vin
- » Re: "direct path read" and "db file sequential read" used for full table scans in 11g- Gaja Krishna Vaidyanatha
- » Re: "direct path read" and "db file sequential read" used for full table scans in 11g- Jonathan Lewis
- » RE: "direct path read" and "db file sequential read" used for full table scans in 11g- bill thater
- » RE: "direct path read" and "db file sequential read" used for full table scans in 11g- Mark W. Farnham
- » Re: "direct path read" and "db file sequential read" used for full table scans in 11g- Gaja Krishna Vaidyanatha
- » Re: "direct path read" and "db file sequential read" used for full table scans in 11g- Jonathan Lewis
- » Re: "direct path read" and "db file sequential read" used for full table scans in 11g- Gaja Krishna Vaidyanatha
- » RE: "direct path read" and "db file sequential read" used for full table scans in 11g- Allen, Brandon
- » Re: "direct path read" and "db file sequential read" used for full table scans in 11g- Tanel Poder
- » RE: "direct path read" and "db file sequential read" used for full table scans in 11g- Allen, Brandon
- » RE: "direct path read" and "db file sequential read" used for full table scans in 11g- Allen, Brandon