Re: "direct path read" and "db file sequential read" used for full table scans in 11g
From: Alex Fatkulin <afatkulin_at_gmail.com>
Date: Thu, 30 Aug 2012 22:08:49 -0400
Message-ID: <CAMVw97LTnMo7tPZa+OKhXZNNjTDgd4OjEBrBQdsyhm=1Deh2Ew_at_mail.gmail.com>
Can you do:
set arraysize 1000
Date: Thu, 30 Aug 2012 22:08:49 -0400
Message-ID: <CAMVw97LTnMo7tPZa+OKhXZNNjTDgd4OjEBrBQdsyhm=1Deh2Ew_at_mail.gmail.com>
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-lReceived on Thu Aug 30 2012 - 21:08:49 CDT