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

From: Alex Fatkulin <afatkulin@xxxxxxxxx>
To: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
Date: Thu, 30 Aug 2012 22:08:49 -0400

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,
http://afatkulin.blogspot.com

Enkitec,
http://www.enkitec.com


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

References:

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

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

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

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

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

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