DBA_ADVISOR_SQLW_SUM displays an aggregated picture of all SQLWkld workload objects in the database.
USER_ADVISOR_SQLW_SUM displays an aggregated picture of the SQLWkld workload objects 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) |
Unique name of the workload | |
DESCRIPTION |
VARCHAR2(256) |
User-specified description of the workload | |
CREATE_DATE |
DATE |
NOT NULL |
Date on which the workload object was created |
MODIFY_DATE |
DATE |
NOT NULL |
Date of last update to the current workload |
NUM_SELECT_STMT |
NUMBER |
Number of SELECT statements in the workload |
|
NUM_UPDATE_STMT |
NUMBER |
Number of UPDATE statements in the workload |
|
NUM_DELETE_STMT |
NUMBER |
Number of DELETE statements in the workload |
|
NUM_INSERT_STMT |
NUMBER |
Number of INSERT statements in the workload |
|
NUM_MERGE_STMT |
NUMBER |
Number of MERGE statements in the workload |
|
SOURCE |
VARCHAR2(30) |
Optional name that identifies the creator of the object | |
HOW_CREATED |
VARCHAR2(30) |
Optional object or template on which the object was based | |
DATA_SOURCE |
VARCHAR2(2000) |
Workload data source | |
READ_ONLY |
VARCHAR2(5) |
Indicates whether or not the workload can be modified or deleted (TRUE) or not (FALSE) |
See Also:
"USER_ADVISOR_SQLW_SUM"