select b.workload_id as workload_id,
c.name as workload_name,
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_sqlw_tabvol 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
SELECT B.WORKLOAD_ID AS WORKLOAD_ID
,
C.NAME AS WORKLOAD_NAME
,
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_SQLW_TABVOL 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
|
|
|