GV$SPPARAMETER definition in Oracle Database 10.2 / www.oracledba.ru
GV$SPPARAMETER
select
INST_ID, -- INST_ID NUMBER
KSPSPFFTCTXSPSID, -- SID VARCHAR2(80)
KSPSPFFTCTXSPNAME, -- NAME VARCHAR2(80)
KSPSPFFTCTXSPVALUE, -- VALUE VARCHAR2(255)
KSPSPFFTCTXSPDVALUE, -- DISPLAY_VALUE VARCHAR2(255)
KSPSPFFTCTXISSPECIFIED, -- ISSPECIFIED VARCHAR2(6)
KSPSPFFTCTXORDINAL, -- ORDINAL NUMBER
KSPSPFFTCTXCOMMENT -- UPDATE_COMMENT VARCHAR2(255)
from
x$kspspfile
WHERE
((translate (KSPSPFFTCTXSPNAME,
'_',
'#') not like '##%') and ((translate (KSPSPFFTCTXSPNAME,
'_',
'#') not like '#%') OR KSPSPFFTCTXISSPECIFIED = 'TRUE'))