DBA_ADVISOR_SQLA_WK_STMTS
displays information about all workload objects in the database after an Access Advisor analysis operation.
USER_ADVISOR_SQLA_WK_STMTS
displays information about the workload objects owned by the current user. This view does not display the OWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
OWNER |
VARCHAR2(30) |
Owner of the task | |
TASK_ID |
NUMBER |
NOT NULL |
Unique identifier of the task |
TASK_NAME |
VARCHAR2(30) |
Name of the task | |
WORKLOAD_ID |
NUMBER |
NOT NULL |
Unique identifier of the workload object |
WORKLOAD_NAME |
VARCHAR2(30) |
Name of the workload | |
SQL_ID |
NUMBER |
NOT NULL |
Generated identifier of the statement |
HASH_VALUE |
NUMBER |
Hash value for the parent statement in the SQL cache | |
USERNAME |
VARCHAR2(30) |
Name of the user executing the statement | |
MODULE |
VARCHAR2(64) |
Name of the module issuing the statement | |
ACTION |
VARCHAR2(64) |
Module action for the statement | |
CPU_TIME |
NUMBER |
Total CPU count (in seconds) of the executing statement | |
BUFFER_GETS |
NUMBER |
Total number of buffer gets for the statement | |
DISK_READS |
NUMBER |
Total disk-read I/O count for the statement | |
ELAPSED_TIME |
NUMBER |
Total elapsed time (in seconds) of the executing statement | |
ROWS_PROCESSED |
NUMBER |
Total number of rows processed by the statement | |
EXECUTIONS |
NUMBER |
Total number of times the statement was executed | |
PRECOST |
NUMBER |
Cost of executing the statement in the workload prior to the recommendations | |
POSTCOST |
NUMBER |
Cost of executing the statement in the workload after the recommendations | |
LAST_EXECUTION_DATE |
DATE |
Date on which the statement was last executed | |
PRIORITY |
NUMBER |
Business importance of the statement:
|
|
COMMAND_TYPE |
NUMBER |
Type of the command | |
STAT_PERIOD |
NUMBER |
Unused | |
SQL_TEXT |
CLOB |
Text of the SQL statement | |
IMPORTANCE |
NUMBER |
Advisor-calculated importance value | |
REC_ID |
NUMBER |
Associated recommendation identifier |
See Also:
"USER_ADVISOR_SQLA_WK_STMTS"