Re: Question - any parameter or hint to FORCE Physical Read (bypass buffer cache)
- From: Sayan Malakshinov <xt.and.r@xxxxxxxxx>
- To: afatkulin@xxxxxxxxx
- Date: Tue, 23 Apr 2013 00:36:04 +0400
Christopher, what is your oracle version?
On 11.2.0.1 "_serial_direct_read" was boolean parameter, besides this,
there are other version-dependent conditions:
http://blog.tanelpoder.com/2012/09/03/optimizer-statistics-driven-direct-path-read-decision-for-full-table-scans-_direct_read_decision_statistics_driven/
On Tue, Apr 23, 2013 at 12:29 AM, Alex Fatkulin <afatkulin@xxxxxxxxx> wrote:
> You need "_serial_direct_read"=always
> On Mon, Apr 22, 2013 at 4:23 PM, <Christopher.Taylor2@xxxxxxxxxxxx> wrote:
>
> > I tried setting:
> > "_serial_direct_read"=TRUE and that does not do it.
> >
> > --
> Alex Fatkulin,
> http://afatkulin.blogspot.com
>
> Enkitec,
> http://www.enkitec.com
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Best regards,
Sayan Malakshinov
Senior performance tuning engineer
PSBank
http://orasql.org
--
//www.freelists.org/webpage/oracle-l
Other related posts:
