[Home] [Help] [Dependency Information]
Object Name: | CDB_SQL_PLAN_DIRECTIVES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Set of sql plan directives in all containers
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 |
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;
|
|
|