Re: Optimizing Programs for ORACLE Apps (RULE Based)

  • From: Tanmoy <tanmoydc@xxxxxxxxx>
  • To: Juan Carlos Reyes Pacheco <juancarlosreyesp@xxxxxxxxx>
  • Date: Mon, 11 Jul 2005 14:46:27 -0400

Hi Juan,

       Thanks for suggesting the same. Due to management decision
there wont be any upgrade. However i can change the session level
parameter for the particular program . I am thinking for doing execute
immediate to change the following parameter for my session

optimizer_mode = CHOOSE
optimizer_max_permutations = 2000 (now 80000)
db_file_multiblock_read_count = 8 ( now 64 )
index_cost_adj = 80
index_cashing = 20 

Do let me know if you suggest something. Current parameter are given
in my original post.

On 7/11/05, Juan Carlos Reyes Pacheco <juancarlosreyesp@xxxxxxxxx> wrote:
> 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.


-- "Time is the coin of life. Only you can determine how it will be spent."

Other related posts: