DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.DBA_OUTLINE_HINTS

Object Details
Object Name: DBA_OUTLINE_HINTS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Hints stored in outlines

[View Source]

Columns
Name Datatype Length Mandatory Comments
NAME VARCHAR2 (128)
Name of the outline
OWNER VARCHAR2 (128)
User who created the outline
NODE NUMBER

I.D. of the query or subquery to which the hint applies
STAGE NUMBER

Stage at which the outline is processed
JOIN_POS NUMBER

Position of the table in the join order
HINT CLOB (4000)
Text of the hint
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT NAME
,      OWNER
,      NODE
,      STAGE
,      JOIN_POS
,      HINT
FROM SYS.DBA_OUTLINE_HINTS;

Dependencies

[top of page]

SYS.DBA_OUTLINE_HINTS references the following:

SchemaOUTLN
TableOL$
TableOL$HINTS
SYS.DBA_OUTLINE_HINTS is referenced by following:

SchemaPUBLIC
SynonymDBA_OUTLINE_HINTS