GV$SYSTEM_PARAMETER2
select x.inst_id, -- INST_ID NUMBER kspftctxpn, -- NUM NUMBER ksppinm, -- NAME VARCHAR2(64) ksppity, -- TYPE NUMBER kspftctxvl, -- 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', 'FALSE'), decode -- ISMODIFIED VARCHAR2(8) (bitand (kspftctxvf, 7), 1, 'MODIFIED', 'FALSE'), decode -- ISADJUSTED VARCHAR2(5) (bitand (kspftctxvf, 2), 2, 'TRUE', 'FALSE'), ksppdesc, -- DESCRIPTION VARCHAR2(64) 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 '#%') or (kspftctxdf = 'FALSE'))

home |  up  |  mailbox