Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E17615-23
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

DBA_SQL_PLAN_DIR_OBJECTS

DBA_SQL_PLAN_DIR_OBJECTS displays the objects created in the SQL plan directive.

Column Datatype NULL Description
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 subobject (for example, column) in the SQL plan directive
OBJECT_TYPE VARCHAR2(6)   The type of the subobject in the SQL plan directive
NOTES XMLTYPE   Other notes about the object

See Also: