eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: SYS.CDB_SQL_PLAN_DIR_OBJECTS

Object Details

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

[View Source]

Columns

Name	Datatype	Length	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

Query Text

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;

Dependencies

[top of page]

SYS.CDB_SQL_PLAN_DIR_OBJECTS references the following:

SYS: DBA_SQL_PLAN_DIR_OBJECTS; DBMS_SPD_INTERNAL - show dependent code; STANDARD - show dependent code; SYS_PLSQL_6A517DAE_9_1; XMLTYPE

SYS.CDB_SQL_PLAN_DIR_OBJECTS is referenced by following:

PUBLIC: CDB_SQL_PLAN_DIR_OBJECTS