VIEW: SYS.USER_ADVISOR_SQLA_WK_MAP

Source

View Text - Preformatted

select a.task_id as task_id,
             b.name as task_name,
             a.workload_id as workload_id,
             a.name as workload_name,
             a.is_sts as is_sts
      from wri$_adv_sqla_map a, wri$_adv_tasks b
      where a.task_id = b.id
        and b.owner# = userenv('SCHEMAID')

View Text - HTML Formatted

SELECT A.TASK_ID AS TASK_ID
, B.NAME AS TASK_NAME
, A.WORKLOAD_ID AS WORKLOAD_ID
, A.NAME AS WORKLOAD_NAME
, A.IS_STS AS IS_STS
FROM WRI$_ADV_SQLA_MAP A
, WRI$_ADV_TASKS B
WHERE A.TASK_ID = B.ID
AND B.OWNER# = USERENV('SCHEMAID')