Change Oracle parameters

[Former Member]

Hello friends,

I need to set/change following param:

sortelimination_cost_ratio - NOT SET - add with value 10

SORTELIMINATION_COST_RATIO 10 (see Note 176754 (16))

optimpeek_user_binds - NOT SET - add with value FALSE

Note 755342 - Incorrect execution plans with bind variable peeking

optimizermjc_enabled - NOT SET - add with value FALSE

OPTIMIZERMJC_ENABLED FALSE (Note 176754 (30))

How can I check if after setting/changing the parameters I need to restart the DB + SAP ?

Can they be changed without restart ?

I am not sure how to check this.

Thanks in advance,

Jordan.

[Former Member · Accepted solution]

Hi Jordan,

Use the following query.

select name, issys_modifiable from v$parameter where name ='<parameter>';

False - Static parameter Compulsory we need to down the database ie Static.

Immediate - Dynamic parameter whhich can be changed without db restart.

deferred - Though we can change the parameter while Oracle is running, the parameter would only be effected after the database restart.

Br,

Venky.

[Former Member · Accepted solution]

Thanks Ven.

Have a good day