Cacher is the code snippet organizer for pro developers

col spfile format a100
set linesize 100
set pagesize 2000
select sid || '.' || name || q'[ = ']' || value || q'[']' as spfile from v$spparameter where isspecified = 'TRUE' order by name, sid;

col name format a40
col value format a60
set linesize 130
set pagesize 2000
SELECT KSPPINM "Name", KSPFTCTXVL "Value" FROM X$KSPPI A, X$KSPPCV2 B
WHERE A.INDX + 1 = KSPFTCTXPN AND KSPFTCTXDF <> 'TRUE' ORDER BY 2;