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')