OWNER |
VARCHAR2(30) |
|
Owner of the workload object |
WORKLOAD_ID |
NUMBER |
NOT NULL |
Unique identifier number 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 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 |
OPTIMIZER_COST |
NUMBER |
|
Cost of executing the statement in the workload prior to the recommendations |
LAST_EXECUTION_DATE |
DATE |
|
Date on which the statement was last executed |
PRIORITY |
NUMBER |
|
Priority of the statement:
-
1 - High
-
2 - Medium
-
3 - Low
|
COMMAND_TYPE |
NUMBER |
|
Type of the command |
STAT_PERIOD |
NUMBER |
|
Unused |
SQL_TEXT |
CLOB |
|
Text of the SQL statement |
VALID |
NUMBER |
|
Indicates whether the statement is valid for analysis:
-
0 - Statement will not be analyzed by the EXECUTE_TASK procedure. Typically, the statement references one or more tables that do not have valid statistics. To correct this problem, ensure that the tables have valid statistics and execute the RESET_SQLWKLD procedure on the current workload.
-
1 - Statement is eligible for analysis by the EXECUTE_TASK procedure.
|