Init.ora

Show non-default parameters

set pages 100
 set lines 100
 select name ||'='||decode(type, 2, '''')||value||decode(type, 2, '''') parameter
 from   v$parameter
 where  1=1
 and    isdefault = 'FALSE'
 and    value is not null
 order  by name;