select b.owner_name as owner,
b.id as workload_id,
b.name as workload_name,
b.description as description,
b.ctime as create_date,
b.mtime as modify_date,
a.num_select as num_select_stmt,
a.num_update as num_update_stmt,
a.num_delete as num_delete_stmt,
a.num_insert as num_insert_stmt,
a.num_merge as num_merge_stmt,
b.source as source,
b.how_created as how_created,
a.data_source as data_source,
decode(bitand(b.property,1),1,'TRUE','FALSE') as read_only
from wri$_adv_sqlw_sum a, wri$_adv_tasks b
where a.workload_id = b.id
and bitand(b.property,2) = 0
and b.advisor_id = 6
SELECT B.OWNER_NAME AS OWNER
,
B.ID AS WORKLOAD_ID
,
B.NAME AS WORKLOAD_NAME
,
B.DESCRIPTION AS DESCRIPTION
,
B.CTIME AS CREATE_DATE
,
B.MTIME AS MODIFY_DATE
,
A.NUM_SELECT AS NUM_SELECT_STMT
,
A.NUM_UPDATE AS NUM_UPDATE_STMT
,
A.NUM_DELETE AS NUM_DELETE_STMT
,
A.NUM_INSERT AS NUM_INSERT_STMT
,
A.NUM_MERGE AS NUM_MERGE_STMT
,
B.SOURCE AS SOURCE
,
B.HOW_CREATED AS HOW_CREATED
,
A.DATA_SOURCE AS DATA_SOURCE
,
DECODE(BITAND(B.PROPERTY
, 1)
, 1
, 'TRUE'
, 'FALSE') AS READ_ONLY
FROM WRI$_ADV_SQLW_SUM A
, WRI$_ADV_TASKS B
WHERE A.WORKLOAD_ID = B.ID
AND BITAND(B.PROPERTY
, 2) = 0
AND B.ADVISOR_ID = 6
|
|
|