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
/