Re: db_file_multiblock_read_count

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