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.
>
--
Regards,
Tanmoy
-- "Time is the coin of life. Only you can determine how it will be spent."
--
//www.freelists.org/webpage/oracle-l
Other related posts:
