DBA_OUTLINE_HINTS

Hints stored in outlines

Columns
   ___________________________
 
   NAME
      Name of the outline
   OWNER
      User who created the outline
   NODE
      I.D. of the query or subquery to which the hint applies
   STAGE
      Stage at which the outline is processed
   JOIN_POS
      Position of the table in the join order
   HINT
      Text of the hint

Related:

DBA_OUTLINES