database init parameters to check whether they are dynamic or static

 MANUALLY GET LIST OF PARAMETERS:

You  can Manually check the parameters in your database by the parameter “v$parameter”.

And the query is

1. Immediate : List of dynamic parameters.

select name from v$parameter where ISSYS_MODIFIABLE=’IMMEDIATE’;

2. DEFERRED : Semi-Dynamic Parameters.

select name from v$parameter where ISSYS_MODIFIABLE=’DEFERRED’;

3. False : Static parameters list.\

select name from v$parameter where ISSYS_MODIFIABLE=’FALSE’;