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)

home |  up