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