VIEW: SYS.DBA_XSTREAM_STMTS

Source

View Text - Preformatted

select ss.handler_name, ss.execution_sequence,
         ss.statement, ss.creation_time, ss.modification_time
  from "_DBA_STREAMS_STMTS" ss,
       (select aph.handler_name
        from DBA_APPLY_DML_HANDLERS aph, DBA_APPLY app
        where aph.apply_name = app.apply_name and
              app.purpose in ('XStream In', 'XStream Out')) apph
  where ss.handler_name = apph.handler_name(+)

View Text - HTML Formatted

SELECT SS.HANDLER_NAME
, SS.EXECUTION_SEQUENCE
, SS.STATEMENT
, SS.CREATION_TIME
, SS.MODIFICATION_TIME
FROM "_DBA_STREAMS_STMTS" SS
, (SELECT APH.HANDLER_NAME
FROM DBA_APPLY_DML_HANDLERS APH
, DBA_APPLY APP
WHERE APH.APPLY_NAME = APP.APPLY_NAME AND APP.PURPOSE IN ('XSTREAM IN'
, 'XSTREAM OUT')) APPH
WHERE SS.HANDLER_NAME = APPH.HANDLER_NAME(+)