GV$SYSTEM_PARAMETER2 definition in Oracle Database 10.2 / www.oracledba.ru
GV$SYSTEM_PARAMETER2
select
x.inst_id, -- INST_ID NUMBER
kspftctxpn, -- NUM NUMBER
ksppinm, -- NAME VARCHAR2(80)
ksppity, -- TYPE NUMBER
kspftctxvl, -- VALUE VARCHAR2(512)
kspftctxdvl, -- DISPLAY_VALUE VARCHAR2(512)
kspftctxdf, -- ISDEFAULT VARCHAR2(6)
decode -- ISSES_MODIFIABLE VARCHAR2(5)
(bitand (ksppiflg/256, 1), 1, 'TRUE', 'FALSE'),
decode -- ISSYS_MODIFIABLE VARCHAR2(9)
(bitand (ksppiflg/65536, 3), 1, 'IMMEDIATE', 2, 'DEFERRED', 3, 'IMMEDIATE', 'FALSE'),
decode -- ISINSTANCE_MODIFIABLE VARCHAR2(5)
(bitand (ksppiflg, 4), 4, 'FALSE', decode (bitand (ksppiflg/65536, 3), 0, 'FALSE', 'TRUE')),
decode -- ISMODIFIED VARCHAR2(8)
(bitand (kspftctxvf, 7), 1, 'MODIFIED', 'FALSE'),
decode -- ISADJUSTED VARCHAR2(5)
(bitand (kspftctxvf, 2), 2, 'TRUE', 'FALSE'),
decode -- ISDEPRECATED VARCHAR2(5)
(bitand (ksppilrmflg/64, 1), 1, 'TRUE', 'FALSE'),
ksppdesc, -- DESCRIPTION VARCHAR2(255)
kspftctxvn, -- ORDINAL NUMBER
kspftctxct -- UPDATE_COMMENT VARCHAR2(255)
from
x$ksppi x,
x$ksppsv2 y
where
((x.indx+1) = kspftctxpn) and ((translate (ksppinm,
'_',
'#') not like '##%') and (translate (ksppinm,
'_',
'#') not like '#%' or (kspftctxdf = 'FALSE') or (bitand (kspftctxvf, 5) > 0)))