In v$parameter we can find one column ie. ISSYS_MODIFIABLE. This column
contains three phases 1) Immediate 2) DEFERRED 3) False
1. Immediate : We can change the parameter in fly database ie Dynamic.(only need to change the value no need to bounce)
2. DEFERRED : We can change the parameter in fly database but this will effect
after restart the database only.(here we need to edit using spfile and bounce the database)
3. False : Compulsory we need to down the database ie Static.
Ex:-
select name ISSYS_MODIFIABLE from v$parameter;
Comments
Post a Comment