V$ script to get INIT.ORA settings.
select name, value, isdefault, isses_modifiable,
issys_modifiable
from v$parameter
order by name
How to list init.ora settings
V$ script to get INIT.ORA settings.
select name, value, isdefault, isses_modifiable,
issys_modifiable
from v$parameter
order by name