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

Home -> Community -> Mailing Lists -> Oracle-L -> Changing from cost to rule bae optimization on the fly

Changing from cost to rule bae optimization on the fly

From: Goodson, Doris <DGoodson_at_SolanoCounty.com>
Date: Fri, 21 Oct 2005 09:56:14 -0700
Message-ID: <F33BF080E9B7F94F98D8F389E09E9598410A1B@excff01.Solano.Sol> 





Hi List,

 



I am running 9.2.0.2 Oracle on AIX 5.2.  My online is acceptable,
however COBOL batch is slow.  Is there a way that I can switch from cost
to rule base optimization for the session running the batch process
without having to shut the system down?

 



Thanks,



Doris



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


Received on Fri Oct 21 2005 - 11:58:23 CDT












Original text of this message













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