Show non-default parameters
select name , value from v$parameter where ismodified != 'FALSE' / or for name='parameter' style...set pages 999 lines 100 select name || '=' || decode(type, 2, '''') || value || decode(type, 2, '''') parameter from v$parameter where isdefault = 'FALSE' and value is not null order by name /
