Skip to Content
avatar image
Former Member

Change Oracle parameters

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Sep 18, 2011 at 12:36 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded