RE: "direct path read" and "db file sequential read" used for full table scans in 11g

From: Allen, Brandon <Brandon.Allen_at_OneNeck.com>
Date: Thu, 30 Aug 2012 21:40:48 +0000
Message-ID: <A250F0C68C23514CA9F3DF63D60EE10E1A82514A_at_onews32>

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_at_gmail.com] 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.
--

http://www.freelists.org/webpage/oracle-l Received on Thu Aug 30 2012 - 16:40:48 CDT