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'))

home |  up  |  mailbox