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: Optimizing Programs for ORACLE Apps (RULE Based)

Re: Optimizing Programs for ORACLE Apps (RULE Based)

From: Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com>
Date: Mon, 11 Jul 2005 09:25:43 -0400
Message-ID: <cd4305c105071106257386e05c@mail.gmail.com> 





Hi Tanmoy, my two cents.


Why don't you try to create a test environment and move to CBO,
recalculate full statistics and see.


Maybe this could be your real solution.


This is risky, but this could solve several present and future problems at once.
Anyway rule mode had been deprecated, there is no reason to continue using it.
Soon or later your system will have to move to cbo, and I think is better soon.

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


Received on Mon Jul 11 2005 - 08:28:06 CDT












Original text of this message













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