V$SES_OPTIMIZER_ENV definition in Oracle Database 11.2

V$SES_OPTIMIZER_ENV

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

home | up