Sometimes we don't know whether we can change the parameters dynamically or not in the oracle database.
We can get those information from v$parameter view.Below is the script to confirm it .
select NAME,ISINSTANCE_MODIFIABLE from v$parameter where NAME='&Parameter';
If ISINSTANCE_MODIFIABLE values show TRUE then we can modify the parameter without bringing down the database
if it is FALSE we need to bring down the database to modify the parameters .
Example:
select NAME,ISINSTANCE_MODIFIABLE from v$parameter where NAME='undo_management';
NAME ISINS
------------------------------ ---------
undo_management FALSE
select NAME,ISINSTANCE_MODIFIABLE from v$parameter where NAME='large_pool_size';
NAME ISINS
--------------------
large_pool_size TRUE
