VIEW: SYS.DBA_ADVISOR_ACTIONS

Source

View Text - Preformatted

select b.owner_name as owner,
             a.task_id as task_id,
             b.name as task_name,
             a.exec_name as execution_name,
             d.rec_id as rec_id,
             a.id as action_id,
             a.obj_id as object_id,
             c.command_name as command,
             a.command as command_id,
             a.flags as flags,
             a.attr1 as attr1,
             a.attr2 as attr2,
             a.attr3 as attr3,
             a.attr4 as attr4,
             a.attr5 as attr5,
             a.attr6 as attr6,
             a.num_attr1 as num_attr1,
             a.num_attr2 as num_attr2,
             a.num_attr3 as num_attr3,
             a.num_attr4 as num_attr4,
             a.num_attr5 as num_attr5,
             dbms_advisor.format_message_group(a.msg_id) as message,
             nvl(a.filtered, 'N') as filtered
      from wri$_adv_actions a, wri$_adv_tasks b, x$keacmdn c,
           wri$_adv_rec_actions d
      where a.task_id = b.id
        and a.command = c.indx
        and d.task_id = a.task_id
        and d.act_id = a.id
        and bitand(b.property,6) = 4
        and ((b.advisor_id = 2 and bitand(a.flags,2048) = 0) or
             (b.advisor_id <> 2))

View Text - HTML Formatted

SELECT B.OWNER_NAME AS OWNER
, A.TASK_ID AS TASK_ID
, B.NAME AS TASK_NAME
, A.EXEC_NAME AS EXECUTION_NAME
, D.REC_ID AS REC_ID
, A.ID AS ACTION_ID
, A.OBJ_ID AS OBJECT_ID
, C.COMMAND_NAME AS COMMAND
, A.COMMAND AS COMMAND_ID
, A.FLAGS AS FLAGS
, A.ATTR1 AS ATTR1
, A.ATTR2 AS ATTR2
, A.ATTR3 AS ATTR3
, A.ATTR4 AS ATTR4
, A.ATTR5 AS ATTR5
, A.ATTR6 AS ATTR6
, A.NUM_ATTR1 AS NUM_ATTR1
, A.NUM_ATTR2 AS NUM_ATTR2
, A.NUM_ATTR3 AS NUM_ATTR3
, A.NUM_ATTR4 AS NUM_ATTR4
, A.NUM_ATTR5 AS NUM_ATTR5
, DBMS_ADVISOR.FORMAT_MESSAGE_GROUP(A.MSG_ID) AS MESSAGE
, NVL(A.FILTERED
, 'N') AS FILTERED
FROM WRI$_ADV_ACTIONS A
, WRI$_ADV_TASKS B
, X$KEACMDN C
, WRI$_ADV_REC_ACTIONS D
WHERE A.TASK_ID = B.ID
AND A.COMMAND = C.INDX
AND D.TASK_ID = A.TASK_ID
AND D.ACT_ID = A.ID
AND BITAND(B.PROPERTY
, 6) = 4
AND ((B.ADVISOR_ID = 2
AND BITAND(A.FLAGS
, 2048) = 0) OR (B.ADVISOR_ID <> 2))