GV$SQL_OPTIMIZER_ENV definition in Oracle Database 11.2
GV$SQL_OPTIMIZER_ENV

select
  INST_ID,                                 -- INST_ID NUMBER
  KQLFSQCE_PHAD,                           -- ADDRESS RAW(8)
  KQLFSQCE_HASH,                           -- HASH_VALUE NUMBER
  KQLFSQCE_SQLID,                          -- SQL_ID VARCHAR2(13)
  KQLFSQCE_HADD,                           -- CHILD_ADDRESS RAW(8)
  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