DBA_ADVISOR_SQLA_WK_MAP

DBA_ADVISOR_SQLA_WK_MAP displays the workload references for all tasks in the database. Workload references are necessary to allow the SQL Access Advisor to find required workload data.

Related View

USER_ADVISOR_SQLA_WK_MAP displays the workload references for the tasks owned by the current user. This view does not display the OWNER column.

Column	Datatype	Description
`OWNER`	`VARCHAR2(30)`	Owner of the task
`TASK_ID`	`NUMBER`	Unique identifier of the task
`TASK_NAME`	`VARCHAR2(30)`	Name of the task
`WORKLOAD_ID`	`NUMBER`	Unique identifier of the workload object
`WORKLOAD_NAME`	`VARCHAR2(30)`	Name of the workload
`IS_STS`	`NUMBER`	Type of workload source: `0` - SQL workload object `1` - SQL Tuning Set