VIEW: SYS.DBA_ADVISOR_SQLW_COLVOL

Source

View Text - Preformatted

select c.owner_name as owner,
             b.workload_id as workload_id,
             c.name as workload_name,
             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_sqlw_colvol b, wri$_adv_tasks c, sys.col$ d,
           wri$_adv_sqlw_tabvol e
      where c.id = b.workload_id
        and d.col# = b.col#
        and e.table# = b.table#
        and bitand(c.property,2) = 0
        and c.advisor_id = 6

View Text - HTML Formatted

SELECT C.OWNER_NAME AS OWNER
, B.WORKLOAD_ID AS WORKLOAD_ID
, C.NAME AS WORKLOAD_NAME
, 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_SQLW_COLVOL B
, WRI$_ADV_TASKS C
, SYS.COL$ D
, WRI$_ADV_SQLW_TABVOL E
WHERE C.ID = B.WORKLOAD_ID
AND D.COL# = B.COL#
AND E.TABLE# = B.TABLE#
AND BITAND(C.PROPERTY
, 2) = 0
AND C.ADVISOR_ID = 6