GV$SQL_OPTIMIZER_ENV
select INST_ID, -- INST_ID NUMBER KQLFSQCE_PHAD, -- ADDRESS RAW(4) KQLFSQCE_HASH, -- HASH_VALUE NUMBER KQLFSQCE_SQLID, -- SQL_ID VARCHAR2(13) KQLFSQCE_HADD, -- CHILD_ADDRESS RAW(4) KQLFSQCE_CHNO, -- CHILD_NUMBER NUMBER KQLFSQCE_PNUM, -- ID NUMBER KQLFSQCE_PNAME, -- NAME VARCHAR2(40) decode -- ISDEFAULT VARCHAR2(3) (bitand (KQLFSQCE_FLAGS, 2), 0, 'NO', 'YES'), KQLFSQCE_PVALUE -- VALUE VARCHAR2(25) from X$KQLFSQCE where bitand (KQLFSQCE_FLAGS, 8) = 0 and (bitand (KQLFSQCE_FLAGS, 4) = 0 or bitand (KQLFSQCE_FLAGS, 2) = 0)

home |  up  |  mailbox