OWNER |
VARCHAR2(30) |
|
Owner of the task |
TASK_NAME |
VARCHAR2(30) |
|
Name of the task |
TASK_ID |
NUMBER |
NOT NULL |
Unique identifier of the task |
SQLSET_ID |
NUMBER |
|
??? |
SQLSET_NAME |
VARCHAR2(30) |
|
??? |
WORKLOAD_NAME |
VARCHAR2(30) |
|
Name of the workload |
SQL_ID |
NUMBER |
NOT NULL |
Generated identifier of the statement |
SQL_SEQ |
NUMBER |
NOT NULL |
??? |
PLAN_HASH_VALUE |
NUMBER |
NOT NULL |
??? |
PARSING_SCHEMA_NAME |
VARCHAR2(30) |
|
??? |
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 |
FIRST_LOAD_TIME |
DATE |
|
??? |
LAST_EXECUTION_DATE |
DATE |
|
Date on which the statement was last executed |
PRIORITY |
NUMBER |
|
Business importance of the statement:
-
1 - High
-
2 - Medium
-
3 - Low
|
COMMAND_TYPE |
NUMBER |
|
Type of the command |
STAT_PERIOD |
NUMBER |
|
Unused |
ACTIVE_STAT_PERIOD |
NUMBER |
|
??? |
SQL_TEXT |
CLOB |
|
Text of the SQL statement |
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 |
IMPORTANCE |
NUMBER |
|
Advisor-calculated importance value |
REC_ID |
NUMBER |
|
Associated recommendation identifier |
VALIDATED |
NUMBER |
|
??? |
