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