select d.owner_name as owner,
b.workload_id as workload_id,
d.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 d
where d.id = b.workload_id
and bitand(d.property,2) = 0
and d.advisor_id = 6
SELECT D.OWNER_NAME AS OWNER
,
B.WORKLOAD_ID AS WORKLOAD_ID
,
D.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 D
WHERE D.ID = B.WORKLOAD_ID
AND BITAND(D.PROPERTY
, 2) = 0
AND D.ADVISOR_ID = 6
|
|
|