| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03  | 
  | 
  | 
PDF · Mobi · ePub | 
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"