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`^Foot 1	`NUMBER`	The number of rows in the object when the directive is created
`NOTES`	`XMLTYPE`	Other notes about the object

^Footnote 1

This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).