VIEW: SYS._DBA_STREAMS_ACTIONS

Source

View Text - Preformatted

SELECT a.msg_id as MESSAGE_ID,
       m.p1 as MESSAGE_ARG1,
       m.p2 as MESSAGE_ARG2,
       m.p3 as MESSAGE_ARG3,
       m.p4 as MESSAGE_ARG4,
       m.p5 as MESSAGE_ARG5,
       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,
       t.advisor_name as ADVISOR_TYPE,
       sysdate as RUN_TIME
FROM wri$_adv_actions a, wri$_adv_tasks t, x$keacmdn c,
     wri$_adv_message_groups m
WHERE a.task_id = t.id
  AND a.command = c.indx
  -- wri$_adv_tasks.property 0x04 -> Task
  AND bitand(t.property,4) = 4
  AND a.task_id = m.task_id
  AND a.msg_id = m.id

View Text - HTML Formatted

SELECT A.MSG_ID AS MESSAGE_ID
, M.P1 AS MESSAGE_ARG1
, M.P2 AS MESSAGE_ARG2
, M.P3 AS MESSAGE_ARG3
, M.P4 AS MESSAGE_ARG4
, M.P5 AS MESSAGE_ARG5
, 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
, T.ADVISOR_NAME AS ADVISOR_TYPE
, SYSDATE AS RUN_TIME FROM WRI$_ADV_ACTIONS A
, WRI$_ADV_TASKS T
, X$KEACMDN C
, WRI$_ADV_MESSAGE_GROUPS M WHERE A.TASK_ID = T.ID
AND A.COMMAND = C.INDX -- WRI$_ADV_TASKS.PROPERTY 0X04 -> TASK
AND BITAND(T.PROPERTY
, 4) = 4
AND A.TASK_ID = M.TASK_ID
AND A.MSG_ID = M.ID