11g-新特性-动态视图-v$sql_hint

从11.1 增加了新的动态视图 v$sql_hint;
/* Name                      Null?    Type        
 ------------------------- -------- ------------
 NAME                               VARCHAR2(64)
 SQL_FEATURE                        VARCHAR2(64)
 CLASS                              VARCHAR2(64)
 INVERSE                            VARCHAR2(64)
 TARGET_LEVEL                       NUMBER      
 PROPERTY                           NUMBER      
 VERSION                            VARCHAR2(25)

 VERSION_OUTLINE                    VARCHAR2(25)*/

select *
  from v$sql_hint
 where name like upper('%&1%')
 order by to_number(substr(version, 1, instr(version, '.') - 1)), version;