select
SESSION_ID, -- SESSION_ID NUMBER
BUGNO, -- BUGNO NUMBER
VALUE, -- VALUE NUMBER
SQL_FEATURE, -- SQL_FEATURE VARCHAR2(64)
DESCRIPTION, -- DESCRIPTION VARCHAR2(64)
OPTIMIZER_FEATURE_ENABLE, -- OPTIMIZER_FEATURE_ENABLE VARCHAR2(25)
EVENT, -- EVENT NUMBER
IS_DEFAULT -- IS_DEFAULT NUMBER
from
GV$SESSION_FIX_CONTROL
where
inst_id=USERENV('Instance')