Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: db_file_multiblock_read_count

Re: db_file_multiblock_read_count

From: David Aldridge <david_at_david-aldridge.com>
Date: Wed, 7 Nov 2007 09:37:04 -0800 (PST)
Message-ID: <959150.76334.qm@web810.biz.mail.mud.yahoo.com> 





No, but it is alterable at the session level.



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



Thanks


Amir



--



http://www.freelists.org/webpage/oracle-l






--



http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 07 2007 - 11:37:04 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US