5.360 DBA_SQL_PLAN_DIRECTIVES
DBA_SQL_PLAN_DIRECTIVES
displays information about the SQL plan directives in the system.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
The identifier of the SQL plan directive |
|
|
|
The type of the SQL plan directive:
|
|
|
|
Indicates whether the SQL plan directive is enabled. Possible values:
|
|
|
|
The state of the SQL plan directive. Possible values include:
|
|
|
|
If |
|
|
|
The reason for creating the SQL plan directive |
|
|
|
The creation timestamp of the SQL plan directive |
|
|
|
The timestamp of most recent modification of the SQL plan directive |
|
|
|
The timestamp of most recent usage of the SQL plan directive |
|
|
|
Extra information about the SQL plan directive |
See Also:
-
Oracle Database SQL Tuning Guide for more information about SQL plan directives