Determine Oracle Database parameter require bounce or not

In v$parameter we can find one column ie. ISSYS_MODIFIABLE. This column

contains three phases

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;

Enjoyyyy Sharig :)