DBA_ADVISOR_SQLW_STMTS

DBA_ADVISOR_SQLW_STMTS displays rows that correspond to all statements in the workload. All columns are guaranteed to be non-null.

Related View

USER_ADVISOR_SQLW_STMTS displays rows that correspond to the statements in the workload owned by the current user. This view does not display the OWNER column.


Column Datatype NULL Description

OWNER

VARCHAR2(128)

 

Owner of the workload object

WORKLOAD_ID

NUMBER

NOT NULL

Unique identifier number of the workload object

WORKLOAD_NAME

VARCHAR2(128)

 

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(128)

 

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.