Adjusting Oracle Parameters

351 Views

Hi,

I´m very confused about the adjustment of the oracle parameters. When I execute the sql sentence I get a several oracle parameters, and in the note 830576 says that i need to adjust only the parameters that appears in this note, is right?

The other parameters that differs the IS_VALUE with SHOULD_BE_VALUE, Must to be changed? Or doesn´t affect at oracle db instance?

In the following recommendation what do i need to do?

optimizer_dynamic_sampling add with value "6" IS_VALUE 2 SHOULD_BE_VALUE 6

-

>It´s mandatory to change the value of this parameter even in the note 830576 not appear explicity?

disableobjstat_del_broadcast add with value "FALSE" IS_VALUE Empty SHOULD_BE_VALUE FALSE

-

>Must to be changed? In the note not appear, but in the script appear that the recommended value should_be_false.

btree_bitmap_plans check if value "FALSE" is suitable (set to FALSE if Winbundle<=2) avoid b*tree conversion to bitmap IS_VALUE FALSE *SHOULD_BE_VALUE *set to FALSE if Winbundle<=2

-

>My WinBundle Patch it´s upper that 2, then I´ve to put the parameter in OK??

inmemory_undo check why set but mentioned with other prerequisites/not mentioned in note IS_VALUE FALSE SHOULD_BE_VALUE Empty

-

>What do i do?

sessions automatic check ok; doublecheck if value "160" is suitable (2*PROCESSES) IS_VALUE 160 SHOULD_BE_VALUE 2*PROCESSES

-

>I don´t understand the doublecheck if value 160 is suitable, what to do?

commit_write ok (is not set; not to be set as explicitly mentioned in note) IS_VALUE Empty SHOULD_BE_VALUE deleted from parameter file

-

>I understant that If this parameter it´s not specified in the note not need to configured in the database, correct?

dispatchers ok (is not set; mentioned with other prerequisites/not mentioned in note) IS_VALUE Empty SHOULD_BE_VALUE Empty

-

>It´s necessary to do something?

A lot of thanks for your advices!