GV$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(10) (bitand (kspftctxvf, 7), 1, 'MODIFIED', 4, 'SYSTEM_MOD', '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$ksppcv2 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  |  mailbox