Re: Hidden paramters issue
From: Kumar Madduri <ksmadduri_at_gmail.com>
Date: Mon, 8 Mar 2010 07:48:31 -0800
Message-ID: <a2b1e7611003080748q2e5ebc82je130cddc21cf1ee2_at_mail.gmail.com>
Hello
I forgot to mention it is oracle apps environment and the notes are 396009.1. Pasting it from the note here
_b_tree_bitmap_plans = FALSE (#MP)
optimizer_secure_view_merging = FALSE (#MP) _sqlexec_progression_cost = 2147483647 (#MP)
Date: Mon, 8 Mar 2010 07:48:31 -0800
Message-ID: <a2b1e7611003080748q2e5ebc82je130cddc21cf1ee2_at_mail.gmail.com>
Hello
I forgot to mention it is oracle apps environment and the notes are 396009.1. Pasting it from the note here
######### # # Optimizer parameters # # The following optimizer parameters must be set as below, and may # not be changed. No other values are supported. # # Refer also to the release-specific section for any additional # optimizer parameters which must be set. # ######### _sort_elimination_cost_ratio =5 (#MP) _like_with_bind_as_equality = TRUE (#MP)_fast_full_scan_enabled = FALSE (#MP)
_b_tree_bitmap_plans = FALSE (#MP)
optimizer_secure_view_merging = FALSE (#MP) _sqlexec_progression_cost = 2147483647 (#MP)
I am going to gather additional infomration by taking trace
Thank you for your time
Kumar
On Mon, Mar 8, 2010 at 12:22 AM, LS Cheng <exriscer_at_gmail.com> wrote:
> Hi
>
> These parameters has following default values:
>
> _fast_full_scan_enabled TRUE
> _b_tree_bitmap_plans TRUE
> _optimizer_cost_based_transformation LINEAR
>
> _sort_elimination_cost_ratio 0
>
> So some of them is default already (most actually).
>
> You hahve said that _fast_full_scan_enabled has to be set to FALSE because
> some ML notes are saying so, can you reference some note numbers? Because I
> havent seen such notes.
>
>
> Thanks
>
> --
> LSC
>
>
>
> O
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Mar 08 2010 - 09:48:31 CST