VIEW: SYS.USER_ADVISOR_SQLW_TABLES

Source

View Text - Preformatted

select b.workload_id as workload_id,
             c.name as workload_name,
             b.sql_id as sql_id,
             b.table_owner  as table_owner,
             b.table_name as table_name
      from wri$_adv_sqlw_tables b, wri$_adv_tasks c
      where c.id = b.workload_id
        and c.owner# = userenv('SCHEMAID')
        and bitand(c.property,2) = 0
        and c.advisor_id = 6

View Text - HTML Formatted

SELECT B.WORKLOAD_ID AS WORKLOAD_ID
, C.NAME AS WORKLOAD_NAME
, B.SQL_ID AS SQL_ID
, B.TABLE_OWNER AS TABLE_OWNER
, B.TABLE_NAME AS TABLE_NAME
FROM WRI$_ADV_SQLW_TABLES B
, WRI$_ADV_TASKS C
WHERE C.ID = B.WORKLOAD_ID
AND C.OWNER# = USERENV('SCHEMAID')
AND BITAND(C.PROPERTY
, 2) = 0
AND C.ADVISOR_ID = 6