VIEW: SYS.DBA_ADVISOR_SQLA_TABVOL

Source

View Text - Preformatted

select a.owner_name as owner,
             a.name as task_name,
             a.id as task_id,
             b.owner_name as table_owner,
             b.table_name as table_name,
             b.upd_freq as update_freq,
             b.ins_freq as insert_freq,
             b.del_freq as delete_freq,
             b.dir_freq as direct_load_freq,
             b.upd_rows as updated_rows,
             b.ins_rows as inserted_rows,
             b.del_rows as deleted_rows,
             b.dir_rows as direct_load_rows
      from wri$_adv_tasks a, wri$_adv_sqla_tabvol b
      where a.id = b.task_id
        and a.advisor_id = 2

View Text - HTML Formatted

SELECT A.OWNER_NAME AS OWNER
, A.NAME AS TASK_NAME
, A.ID AS TASK_ID
, B.OWNER_NAME AS TABLE_OWNER
, B.TABLE_NAME AS TABLE_NAME
, B.UPD_FREQ AS UPDATE_FREQ
, B.INS_FREQ AS INSERT_FREQ
, B.DEL_FREQ AS DELETE_FREQ
, B.DIR_FREQ AS DIRECT_LOAD_FREQ
, B.UPD_ROWS AS UPDATED_ROWS
, B.INS_ROWS AS INSERTED_ROWS
, B.DEL_ROWS AS DELETED_ROWS
, B.DIR_ROWS AS DIRECT_LOAD_ROWS
FROM WRI$_ADV_TASKS A
, WRI$_ADV_SQLA_TABVOL B
WHERE A.ID = B.TASK_ID
AND A.ADVISOR_ID = 2