GV$PARAMETER

select
x.inst_id,               -- INST_ID NUMBER
x.indx+1,                -- NUM NUMBER
ksppinm,                 -- NAME VARCHAR2(80)
ksppity,                 -- TYPE NUMBER
ksppstvl,                -- VALUE VARCHAR2(512)
ksppstdvl,               -- DISPLAY_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                   -- ISINSTANCE_MODIFIABLE VARCHAR2(5)
  (bitand (ksppiflg, 4), 4, 'FALSE', decode (bitand (ksppiflg/65536, 3), 0, 'FALSE', 'TRUE')),
decode                   -- ISMODIFIED VARCHAR2(10)
  (bitand (ksppstvf, 7), 1, 'MODIFIED', 4, 'SYSTEM_MOD', 'FALSE'),
decode                   -- ISADJUSTED VARCHAR2(5)
  (bitand (ksppstvf, 2), 2, 'TRUE', 'FALSE'),
decode                   -- ISDEPRECATED VARCHAR2(5)
  (bitand (ksppilrmflg/64, 1), 1, 'TRUE', 'FALSE'),
ksppdesc,                -- DESCRIPTION VARCHAR2(255)
ksppstcmnt,              -- UPDATE_COMMENT VARCHAR2(255)
ksppihash                -- HASH NUMBER
from
x$ksppi x,
x$ksppcv y 
where
(x.indx = y.indx) and ((translate (ksppinm,
'_',
'#') not like '##%') and ((translate (ksppinm,
'_',
'#') not like '#%') or (ksppstdf = 'FALSE') or (bitand (ksppstvf, 5) > 0)))
home |  up  |  mailbox