DBA_ADVISOR_SQLW_TEMPLATES displays an aggregated picture of all SQLWkld template objects in the database.

Related View

USER_ADVISOR_SQLW_TEMPLATES displays an aggregated picture of the SQLWkld template 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
SOURCE VARCHAR2(30)   Optional object or template on which the object was based
READ_ONLY VARCHAR2(5)   Indicates whether the workload template can be modified or deleted (TRUE) or not (FALSE)