V$SYS_OPTIMIZER_ENV definition in Oracle Database 11.2

V$SYS_OPTIMIZER_ENV

select
  ID,                                      -- ID NUMBER
  NAME,                                    -- NAME VARCHAR2(40)
  SQL_FEATURE,                             -- SQL_FEATURE VARCHAR2(64)
  ISDEFAULT,                               -- ISDEFAULT VARCHAR2(3)
  VALUE,                                   -- VALUE VARCHAR2(25)
  DEFAULT_VALUE                            -- DEFAULT_VALUE VARCHAR2(25)
from
  GV$SYS_OPTIMIZER_ENV
where
  INST_ID = USERENV('Instance')

home | up