Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

Query user_outline_hints table

SQL> SQL> select name, hint   2  from user_outline_hints   3  where rownum < 50   4  / NAME ------------------------------ HINT -------------------------------------------------------------------------------- MYOUTLINE FULL(@"SEL$1" "EMP"@"SEL$1") MYOUTLINE OUTLINE_LEAF(@"SEL$1") MYOUTLINE ALL_ROWS NAME ------------------------------ HINT -------------------------------------------------------------------------------- MYOUTLINE OPTIMIZER_FEATURES_ENABLE('10.2.0.1') MYOUTLINE IGNORE_OPTIM_EMBEDDED_HINTS SQL> SQL>