/*+ *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@xxxxxxxxx> 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 > > -- > //www.freelists.org/webpage/oracle-l > > >