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(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.