DBA_SQL_PLAN_DIR_OBJECTS displays the objects created in the SQL plan directive.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
The identifier of the SQL plan directive |
|
|
|
|
The username of the owner of the object in the SQL plan directive |
|
|
|
|
The name of the object in the SQL plan directive |
|
|
|
|
The name of the subobject (for example, column) in the SQL plan directive |
|
|
|
|
The type of the subobject in the SQL plan directive |
|
|
|
|
Other notes about the object |
See Also:
Oracle Database SQL Tuning Guide for more information about SQL plan directives