[Home] [Help] [Dependency Information]
Object Name: | CDB_SQL_PLAN_DIR_OBJECTS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Set of objects in sql plan directive in all containers
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DIRECTIVE_ID | NUMBER | The identifier of the sql plan directive | ||
OWNER | VARCHAR2 | (128) | The username of the owner of the object in the sql plan directive | |
OBJECT_NAME | VARCHAR2 | (128) | The name of the object in the sql plan directive | |
SUBOBJECT_NAME | VARCHAR2 | (128) | The name of the sub-object (for example column) in the sql plan directive | |
OBJECT_TYPE | VARCHAR2 | (6) | The type of the (sub-)object in the sql plan directive | |
NOTES | XMLTYPE | (64) | Other notes about the object | |
CON_ID | NUMBER | container id |
Cut, paste (and edit) the following text to query this object:
SELECT DIRECTIVE_ID
, OWNER
, OBJECT_NAME
, SUBOBJECT_NAME
, OBJECT_TYPE
, NOTES
, CON_ID
FROM SYS.CDB_SQL_PLAN_DIR_OBJECTS;
|
|
|