Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)

Part Number B28320-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF


DBA_ADVISOR_SQLW_SUM displays an aggregated picture of all SQLWkld workload objects in the database.

Related View

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)