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

VIEW: SYS.CDB_OUTLINE_HINTS

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

Hints stored in outlines in all containers

[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
CON_ID NUMBER

container id
Query Text

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


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

Dependencies

[top of page]

SYS.CDB_OUTLINE_HINTS does not reference any database object

SYS.CDB_OUTLINE_HINTS is referenced by following:

SchemaPUBLIC
SynonymCDB_OUTLINE_HINTS