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

#########
#
# 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-l

Received on Mon Mar 08 2010 - 09:48:31 CST