GV$SYSTEM_PARAMETER2 definition in Oracle Database 11.2
GV$SYSTEM_PARAMETER2

select
  x.inst_id,                               -- INST_ID NUMBER
  kspftctxpn,                              -- NUM NUMBER
  ksppinm,                                 -- NAME VARCHAR2(80)
  ksppity,                                 -- TYPE NUMBER
  kspftctxvl,                              -- VALUE VARCHAR2(4000)
  kspftctxdvl,                             -- DISPLAY_VALUE VARCHAR2(4000)
  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'),
  decode(                                  -- ISBASIC VARCHAR2(5)
    bitand(ksppilrmflg/268435456, 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)))

home |  up