VIEW: SYS._DBA_STREAMS_FINDINGS

Source

View Text - Preformatted

SELECT f.msg_id MESSAGE_ID,
       m.p1 MESSAGE_ARG1,
       m.p2 MESSAGE_ARG2,
       m.p3 MESSAGE_ARG3,
       m.p4 MESSAGE_ARG4,
       m.p5 MESSAGE_ARG5,
       f.type,
       f.more_info_id,
       i.p1 INFO_ARG1,
       i.p2 INFO_ARG2,
       i.p3 INFO_ARG3,
       i.p4 INFO_ARG4,
       i.p5 INFO_ARG5,
       t.advisor_name ADVISOR_TYPE,
       sysdate RUN_TIME
FROM wri$_adv_tasks t,
     wri$_adv_findings f,
     wri$_adv_message_groups m,
     wri$_adv_message_groups i
WHERE f.task_id = t.id AND
      -- wri$_adv_tasks.property 0x04 -> Task
      bitand(t.property,4) = 4 AND
      f.task_id = m.task_id AND f.msg_id = m.id AND
      f.task_id = i.task_id AND f.more_info_id = i.id

View Text - HTML Formatted

SELECT F.MSG_ID MESSAGE_ID
, M.P1 MESSAGE_ARG1
, M.P2 MESSAGE_ARG2
, M.P3 MESSAGE_ARG3
, M.P4 MESSAGE_ARG4
, M.P5 MESSAGE_ARG5
, F.TYPE
, F.MORE_INFO_ID
, I.P1 INFO_ARG1
, I.P2 INFO_ARG2
, I.P3 INFO_ARG3
, I.P4 INFO_ARG4
, I.P5 INFO_ARG5
, T.ADVISOR_NAME ADVISOR_TYPE
, SYSDATE RUN_TIME FROM WRI$_ADV_TASKS T
, WRI$_ADV_FINDINGS F
, WRI$_ADV_MESSAGE_GROUPS M
, WRI$_ADV_MESSAGE_GROUPS I WHERE F.TASK_ID = T.ID AND -- WRI$_ADV_TASKS.PROPERTY 0X04 -> TASK BITAND(T.PROPERTY
, 4) = 4 AND F.TASK_ID = M.TASK_ID
AND F.MSG_ID = M.ID AND F.TASK_ID = I.TASK_ID
AND F.MORE_INFO_ID = I.ID