GV$PARAMETER definition in Oracle 8i / www.oracledba.ru
GV$PARAMETER
select
x.inst_id, -- INST_ID NUMBER
x.indx+1, -- NUM NUMBER
ksppinm, -- NAME VARCHAR2(64)
ksppity, -- TYPE NUMBER
ksppstvl, -- VALUE VARCHAR2(512)
ksppstdf, -- ISDEFAULT VARCHAR2(9)
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 -- ISMODIFIED VARCHAR2(10)
(bitand (ksppstvf, 7), 1, 'MODIFIED', 4, 'SYSTEM_MOD', 'FALSE'),
decode -- ISADJUSTED VARCHAR2(5)
(bitand (ksppstvf, 2), 2, 'TRUE', 'FALSE'),
ksppdesc -- DESCRIPTION VARCHAR2(64)
from
x$ksppi x,
x$ksppcv y
where
(x.indx = y.indx) and ((translate (ksppinm,
'_',
'#') not like '#%') or (ksppstdf = 'FALSE'))