5.361 DBA_SQL_PLAN_BASELINES
DBA_SQL_PLAN_BASELINES
displays information about the SQL plan baselines currently created for specific SQL statements.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Unique SQL identifier generated from normalized SQL text |
|
|
|
Unique SQL identifier in string form as a search key |
|
|
|
Un-normalized SQL text |
|
|
|
Unique plan identifier in string form as a search key |
|
|
|
User who created the plan baseline |
|
|
|
How the plan baseline was created:
|
|
|
|
Name of the parsing schema |
|
|
|
Text description provided for the plan baseline |
|
|
|
Database version at the time of plan baseline creation |
|
|
|
Timestamp when the plan baseline was created |
|
|
|
Timestamp when the plan baseline was last modified |
|
|
|
Timestamp when the plan baseline was last executed |
|
|
|
Timestamp when the plan baseline was last verified |
|
|
|
Indicates whether the plan baseline is enabled ( |
|
|
|
Indicates whether the plan baseline is accepted ( |
|
|
|
Indicates whether the plan baseline is fixed ( |
|
|
|
Indicates whether the optimizer was able to reproduce the plan ( |
|
|
|
Indicates whether the plan baseline is auto-purged ( |
|
|
|
Indicates whether a plan that is automatically captured by SQL plan management is marked adaptive or not. When a new adaptive plan is found for a SQL statement that has an existing SQL plan baseline, that new plan will be added to the SQL plan baseline as an unaccepted plan, and the |
|
|
|
Optimizer cost at the time the plan baseline was created |
|
|
|
Application module name |
|
|
|
Application action |
|
|
Number of executions at the time the plan baseline was created |
|
|
|
|
Total elapsed time at the time the plan baseline was created |
|
|
|
Total CPU time at the time the plan baseline was created |
|
|
|
Total buffer gets at the time the plan baseline was created |
|
|
|
Total disk reads at the time the plan baseline was created |
|
|
|
Total direct writes at the time the plan baseline was created |
|
|
|
Total rows processed at the time the plan baseline was created |
|
|
|
Total number of fetches at the time the plan baseline was created |
|
|
|
Total number of full fetches at the time the plan baseline was created |
Footnote 1
If the value of the ORIGIN
column is equal to AUTO-CAPTURE
, then data for this column is not populated.
See Also:
-
Oracle Database SQL Tuning Guide for more information about SQL plan baselines
-
The
DBMS_SQLTUNE
package in Oracle Database PL/SQL Packages and Types Reference