VIEW: SYS.DBA_STREAMS_STMT_HANDLERS

Source

View Text - Preformatted

select ssh.handler_name, ssh.handler_comment, ssh.creation_time,
         ssh.modification_time
  from "_DBA_STREAMS_STMT_HANDLERS" ssh,
       (select aph.handler_name
        from DBA_APPLY_DML_HANDLERS aph, DBA_APPLY app
        where aph.apply_name = app.apply_name and
              app.purpose NOT IN ('XStream In','XStream_Out',
                           'GoldenGate Capture', 'GoldenGate Apply')) apph
  where ssh.handler_name = apph.handler_name(+)

View Text - HTML Formatted

SELECT SSH.HANDLER_NAME
, SSH.HANDLER_COMMENT
, SSH.CREATION_TIME
, SSH.MODIFICATION_TIME
FROM "_DBA_STREAMS_STMT_HANDLERS" SSH
, (SELECT APH.HANDLER_NAME
FROM DBA_APPLY_DML_HANDLERS APH
, DBA_APPLY APP
WHERE APH.APPLY_NAME = APP.APPLY_NAME AND APP.PURPOSE NOT IN ('XSTREAM IN'
, 'XSTREAM_OUT'
, 'GOLDENGATE CAPTURE'
, 'GOLDENGATE APPLY')) APPH
WHERE SSH.HANDLER_NAME = APPH.HANDLER_NAME(+)