Re: db_file_multiblock_read_count

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_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.

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