GV$SYS_OPTIMIZER_ENV
select INST_ID, -- INST_ID NUMBER PNUM_QKSCESYROW, -- ID NUMBER PNAME_QKSCESYROW, -- NAME VARCHAR2(40) decode -- ISDEFAULT VARCHAR2(3) (bitand (FLAGS_QKSCESYROW, 2), 0, 'NO', 'YES'), PVALUE_QKSCESYROW, -- VALUE VARCHAR2(25) DEFPVALUE_QKSCESYROW -- DEFAULT_VALUE VARCHAR2(25) from X$QKSCESYS where bitand (FLAGS_QKSCESYROW, 8) = 0 and (bitand (FLAGS_QKSCESYROW, 4) = 0 or bitand (FLAGS_QKSCESYROW, 2) = 0)

home |  up  |  mailbox