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 of the workload object |
|
|
|
|
Unique identifier number of the workload object |
|
|
Name of the workload |
|
|
|
|
Generated identifier of the statement |
|
|
Hash value for the parent statement in the cache |
|
|
|
Name of the user executing the statement |
|
|
|
Name of the module issuing the statement |
|
|
|
Module action for the statement |
|
|
|
Total CPU count (in seconds) of the executing statement |
|
|
|
Total number of buffer gets for the statement |
|
|
|
Total disk-read I/O count for the statement |
|
|
|
Total elapsed time (in seconds) of the executing statement |
|
|
|
Total number of rows processed by the statement |
|
|
|
Total number of times the statement was executed |
|
|
|
Cost of executing the statement in the workload prior to the recommendations |
|
|
|
Date on which the statement was last executed |
|
|
|
Priority of the statement:
|
|
|
|
Type of the command |
|
|
|
Unused |
|
|
|
Text of the SQL statement |
|
|
|
Indicates whether the statement is valid for analysis:
|
See Also: