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

VIEW: SYS.CDB_OUTLINES

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

Stored 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
CATEGORY VARCHAR2 (128)
Category to which the outline belongs
USED VARCHAR2 (6)
Flag indicating whether the outline has ever been used
TIMESTAMP DATE

Timestamp at which the outline was created
VERSION VARCHAR2 (64)
Oracle Version that created the outline
SIGNATURE RAW (16)
Signature uniquely identifying the outline SQL text
COMPATIBLE VARCHAR2 (12)
Flag indicating whether the outline hints were compatible across migration
ENABLED VARCHAR2 (8)
Flag indicating whether the outline is enabled
FORMAT VARCHAR2 (6)
Flag indicating what hint format is used
MIGRATED VARCHAR2 (12)
Flag indicating whether the outline has been migrated to SQL plan baseline
CON_ID NUMBER

container id
Query Text

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


SELECT NAME
,      OWNER
,      CATEGORY
,      USED
,      TIMESTAMP
,      VERSION
,      SIGNATURE
,      COMPATIBLE
,      ENABLED
,      FORMAT
,      MIGRATED
,      CON_ID
FROM SYS.CDB_OUTLINES;

Dependencies

[top of page]

SYS.CDB_OUTLINES does not reference any database object

SYS.CDB_OUTLINES is referenced by following:

SchemaPUBLIC
SynonymCDB_OUTLINES