V$SQL_OPTIMIZER_ENV definition in Oracle Database 11.2
V$SQL_OPTIMIZER_ENV

select
  ADDRESS,                                 -- ADDRESS RAW(8)
  HASH_VALUE,                              -- HASH_VALUE NUMBER
  SQL_ID,                                  -- SQL_ID VARCHAR2(13)
  CHILD_ADDRESS,                           -- CHILD_ADDRESS RAW(8)
  CHILD_NUMBER,                            -- CHILD_NUMBER NUMBER
  ID,                                      -- ID NUMBER
  NAME,                                    -- NAME VARCHAR2(40)
  ISDEFAULT,                               -- ISDEFAULT VARCHAR2(3)
  VALUE                                    -- VALUE VARCHAR2(25)
from
  GV$SQL_OPTIMIZER_ENV
where
  INST_ID = USERENV('Instance')

home |  up