Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: db_file_multiblock_read_count

Re: db_file_multiblock_read_count

From: Vlad Sadilovskiy <vlovsky_at_gmail.com>
Date: Wed, 7 Nov 2007 12:58:25 -0500
Message-ID: <df9f25d50711070958o20766e60l495d6e9ea539d533@mail.gmail.com>


Amir, sorry, forgot to mention. This might not work if you have system statistics and CPU costing is on. And one more thing, it is a documented hint in 11g.

Vlad Sadilovskiy
Oracle Database Tools
Web site: http://www.fourthelephant.com
Blog: http://vsadilovskiy.wordpress.com

On 11/7/07, Vlad Sadilovskiy <vlovsky_at_gmail.com> wrote:
>
> /*+ *opt_param*(parameter, value) */
>
> I think this is not widely supported however. Ask Oracle TS.
> Vlad Sadilovskiy
> Oracle Database Tools
> Web site: http://www.fourthelephant.com
> Blog: http://vsadilovskiy.wordpress.com
>
>
>
> On 11/7/07, Hameed, Amir <Amir.Hameed_at_xerox.com> wrote:
> >
> > Folks,
> > Is there is way to pass MRBC as a hint to a SQL statement? The DB is
> > 10.2.0.2. I have tried /*+ (db_file_multiblock_read_count,16) */ but it
> > did not work. May be it is not possible but I want to confirm.
> >
> > Thanks
> > Amir
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 07 2007 - 11:58:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US