Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E17110-04
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_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 NULL 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