mps9029

 Profile Answers by mps9029 

• Jul 1st, 2009

 

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.
2. DEFERRED : We can change the parameter in fly database but this will effect
after restart the database only.
3. False : Compulsory we need to down the database ie Static.

Example:

select name, ISSYS_MODIFIABLE from v$parameter;