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

VIEW: SYS.CDB_SQL_PLAN_DIRECTIVES

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

Set of sql plan directives in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
DIRECTIVE_ID NUMBER
Yes The identifier of the sql plan directive
TYPE VARCHAR2 (16)
The type of the sql plan directive
ENABLED VARCHAR2 (3)
Whether the sql plan directive is enabled or not
STATE VARCHAR2 (10)
The state of the sql plan directive
AUTO_DROP VARCHAR2 (3)
If YES, the sql plan directive gets dropped when unused beyond SPD_RETENTION_WEEKS
REASON VARCHAR2 (36)
The reason for creating the sql plan directive
CREATED TIMESTAMP(6) (20)
The creation timestamp of the sql plan directive
LAST_MODIFIED TIMESTAMP(6) (20)
The timestamp of most recent modification of the sql plan directive
LAST_USED TIMESTAMP(9) (20)
The timestamp of most recent usage of the sql plan directive
NOTES XMLTYPE (64)
Extra information about the sql plan directive
CON_ID NUMBER

container id
Query Text

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


SELECT DIRECTIVE_ID
,      TYPE
,      ENABLED
,      STATE
,      AUTO_DROP
,      REASON
,      CREATED
,      LAST_MODIFIED
,      LAST_USED
,      NOTES
,      CON_ID
FROM SYS.CDB_SQL_PLAN_DIRECTIVES;

Dependencies

[top of page]

SYS.CDB_SQL_PLAN_DIRECTIVES references the following:

SchemaSYS
ViewDBA_SQL_PLAN_DIRECTIVES
PL/SQL PackageDBMS_SPD_INTERNAL - show dependent code
PL/SQL PackageSTANDARD - show dependent code
TYPEXMLTYPE
SYS.CDB_SQL_PLAN_DIRECTIVES is referenced by following:

SchemaPUBLIC
SynonymCDB_SQL_PLAN_DIRECTIVES