Re: db_file_multiblock_read

From: Vlad Sadilovskiy <vlovsky_at_gmail.com>
Date: Wed, 7 Nov 2007 12:55:37 -0500
Message-ID: <df9f25d50711070955p7c22703eh4e533bdc0e382dd0@mail.gmail.com>

/*+ *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:55:37 CST

Re: db_file_multiblock_read_count