VIEW: SYS.USER_ADVISOR_SQLA_COLVOL

Source

View Text - Preformatted

select a.name as task_name,
             a.id as task_id,
             e.owner_name as table_owner,
             e.table_name as table_name,
             d.name as column_name,
             b.upd_freq as update_freq,
             b.upd_rows as updated_rows
      from wri$_adv_tasks a, wri$_adv_sqla_colvol b,
           sys.col$ d,wri$_adv_sqla_tabvol e
      where a.id = b.task_id
        and a.id = e.task_id
        and d.col# = b.col#
        and e.table# = b.table#
        and a.owner# = userenv('SCHEMAID')
        and a.advisor_id = 2

View Text - HTML Formatted

SELECT A.NAME AS TASK_NAME
, A.ID AS TASK_ID
, E.OWNER_NAME AS TABLE_OWNER
, E.TABLE_NAME AS TABLE_NAME
, D.NAME AS COLUMN_NAME
, B.UPD_FREQ AS UPDATE_FREQ
, B.UPD_ROWS AS UPDATED_ROWS
FROM WRI$_ADV_TASKS A
, WRI$_ADV_SQLA_COLVOL B
, SYS.COL$ D
, WRI$_ADV_SQLA_TABVOL E
WHERE A.ID = B.TASK_ID
AND A.ID = E.TASK_ID
AND D.COL# = B.COL#
AND E.TABLE# = B.TABLE#
AND A.OWNER# = USERENV('SCHEMAID')
AND A.ADVISOR_ID = 2