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.DBA_SQL_PLAN_DIR_OBJECTS

Object Details

Object Name:	DBA_SQL_PLAN_DIR_OBJECTS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Set of objects in sql plan directive

[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

Query Text

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


SELECT DIRECTIVE_ID
,      OWNER
,      OBJECT_NAME
,      SUBOBJECT_NAME
,      OBJECT_TYPE
,      NOTES
FROM SYS.DBA_SQL_PLAN_DIR_OBJECTS;

Dependencies

[top of page]

SYS.DBA_SQL_PLAN_DIR_OBJECTS references the following:

SYS: COL$; DBMS_SPD_INTERNAL - show dependent code; OBJ$; STANDARD - show dependent code; SYS_PLSQL_6A517DAE_9_1; USER$; XMLTYPE; _BASE_OPT_DIRECTIVE; _BASE_OPT_FINDING_OBJ; _BASE_OPT_FINDING_OBJ_COL

SYS.DBA_SQL_PLAN_DIR_OBJECTS is referenced by following:

PUBLIC: DBA_SQL_PLAN_DIR_OBJECTS
SYS: CDB_SQL_PLAN_DIR_OBJECTS; DBMS_FEATURE_SPD - show dependent code; DBMS_SPD_INTERNAL - show dependent code