Determine Static or Dinamic Parameter Oracle

When we want to change any parameter in oracle, then we want to know that the parameter we want to change need restart the database or not??

In v$parameter we can find one column ie. ISSYS_MODIFIABLE. This column
contains three phases 1. Immediate 2. Deferred 3. False

here's the explanation
1. Immediate : We can change the parameter in fly database (Dynamic).

2. Deferred : We can change the parameter in fly database but this will effect
after restart the database only (need restart)

3. False : Compulsory we need to down the database (static & Must restart)


Example:
select name, ISSYS_MODIFIABLE from v$parameter;


Enjoyyy...