DBA_SQL_PLAN_DIR

5.352 DBA_SQL_PLAN_DIR_OBJECTS

DBA_SQL_PLAN_DIR_OBJECTS displays the objects created in the SQL plan directive.

Column	Datatype	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
`NUM_ROWS`	`NUMBER`	The number of rows in the object when the directive is created This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).
`NOTES`	`XMLTYPE`	Other notes about the object