Re: db_file_multiblock_read_count

  • From: David Aldridge <david@xxxxxxxxxxxxxxxxxx>
  • To: Amir.Hameed@xxxxxxxxx, oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 7 Nov 2007 09:37:04 -0800 (PST)

No, but it is alterable at the session level.

"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



Other related posts: