Re: Optimizing Programs for ORACLE Apps (RULE Based)

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


-- 
Regards,
Tanmoy 

-- "Time is the coin of life. Only you can determine how it will be spent."
--
http://www.freelists.org/webpage/oracle-l

Other related posts: