Re: db_file_multiblock_read_count

  • From: "Don Seiler" <don@xxxxxxxxx>
  • To: Amir.Hameed@xxxxxxxxx
  • Date: Wed, 7 Nov 2007 10:59:59 -0600

I don't think that kind of thing is HINTable, but you can alter your
session to (re)define the value.  You'll need the ALTER SESSION
privilege though.

Don.

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.

-- 
Don Seiler
http://seilerwerks.wordpress.com
ultimate: http://www.mufc.us
--
//www.freelists.org/webpage/oracle-l


Other related posts: