select
NAME, -- NAME VARCHAR2(64)
SQL_FEATURE, -- SQL_FEATURE VARCHAR2(64)
CLASS, -- CLASS VARCHAR2(64)
INVERSE, -- INVERSE VARCHAR2(64)
TARGET_LEVEL, -- TARGET_LEVEL NUMBER
PROPERTY, -- PROPERTY NUMBER
VERSION, -- VERSION VARCHAR2(25)
VERSION_OUTLINE -- VERSION_OUTLINE VARCHAR2(25)
from
gv$sql_hint
where
inst_id=USERENV('Instance')