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

From: Alex Fatkulin <>
Date: Thu, 30 Aug 2012 22:08:49 -0400
Message-ID: <>

Can you do:
set arraysize 1000

In sql*plus and then run it and see if there are any changes? Flush your buffer cache before you do it.

On Thursday, August 30, 2012, Allen, Brandon wrote:

> ------------------------------
> 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.

Alex Fatkulin,


Received on Thu Aug 30 2012 - 21:08:49 CDT

Original text of this message