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)