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