5.47 DBA_ADVISOR_SQLW_SUM

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(128)

Owner of the workload object

WORKLOAD_ID

NUMBER

NOT NULL

Unique identifier number of the workload object

WORKLOAD_NAME

VARCHAR2(128)

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(128)

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"