GV$SYS_OPTIMIZER_ENV definition in Oracle Database 11.2
GV$SYS_OPTIMIZER_ENV
select
INST_ID, -- INST_ID NUMBER
PNUM_QKSCESYROW, -- ID NUMBER
PNAME_QKSCESYROW, -- NAME VARCHAR2(40)
FID_QKSCESYROW, -- SQL_FEATURE VARCHAR2(64)
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)