4.33 DBA_ADVISOR_SQLA_WK_STMTS
DBA_ADVISOR_SQLA_WK_STMTS
displays information about all workload objects in the database after an Access Advisor analysis operation.
Related View
USER_ADVISOR_SQLA_WK_STMTS
displays information about the workload objects owned by the current user after an Access Advisor analysis operation. This view does not display the OWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the task |
|
|
|
Name of the task |
|
|
|
Unique identifier of the task |
|
|
|
ID of the SQL tuning set for the statement |
|
|
|
Name of the SQL tuning set for the statement |
|
|
|
Name of the workload |
|
|
|
Generated identifier of the statement |
|
|
|
SQL sequence |
|
|
|
Numerical representation of the SQL plan for the cursor. Comparing one |
|
|
|
Schema name that was used to originally build this child cursor |
|
|
|
Name of the user executing the statement |
|
|
|
Name of the module issuing the statement |
|
|
|
Module action for the statement |
|
|
|
Total CPU count (in seconds) of the executing statement |
|
|
|
Total number of buffer gets for the statement |
|
|
|
Total disk-read I/O count for the statement |
|
|
|
Total elapsed time (in seconds) of the executing statement |
|
|
|
Total number of rows processed by the statement |
|
|
|
Total number of times the statement was executed |
|
|
|
Load time of parent cursor |
|
|
|
Date on which the statement was last executed |
|
|
|
Business importance of the statement:
|
|
|
|
Type of the command |
|
|
|
Unused |
|
|
|
Effective period of time (in seconds) during which the SQL statement was active |
|
|
|
Text of the SQL statement |
|
|
|
Cost of executing the statement in the workload prior to the recommendations |
|
|
|
Cost of executing the statement in the workload after the recommendations |
|
|
|
Advisor-calculated importance value |
|
|
|
Associated recommendation identifier |
|
|
|
Indicates whether the statement is valid for analysis:
|
See Also: