VIEW: SYS._DBA_XSTREAM_CONNECTION

Source

View Text - Preformatted

select
  xs.server_name outbound_server, xs.cap_src_database outbound_source_db,
  c.inbound_server, c.inbound_server_dblink,
  c.outbound_queue_owner, c.outbound_queue_name, c.inbound_queue_owner,
  c.inbound_queue_name, c.rule_set_owner, c.rule_set_name,
  c.negative_rule_set_owner, c.negative_rule_set_name, c.flags, c.status,
  c.create_date, c.error_message, c.error_date, c.acked_scn
from sys.xstream$_server_connection c, sys.xstream$_server xs where
  c.outbound_server = xs.server_name

View Text - HTML Formatted

SELECT XS.SERVER_NAME OUTBOUND_SERVER
, XS.CAP_SRC_DATABASE OUTBOUND_SOURCE_DB
, C.INBOUND_SERVER
, C.INBOUND_SERVER_DBLINK
, C.OUTBOUND_QUEUE_OWNER
, C.OUTBOUND_QUEUE_NAME
, C.INBOUND_QUEUE_OWNER
, C.INBOUND_QUEUE_NAME
, C.RULE_SET_OWNER
, C.RULE_SET_NAME
, C.NEGATIVE_RULE_SET_OWNER
, C.NEGATIVE_RULE_SET_NAME
, C.FLAGS
, C.STATUS
, C.CREATE_DATE
, C.ERROR_MESSAGE
, C.ERROR_DATE
, C.ACKED_SCN FROM SYS.XSTREAM$_SERVER_CONNECTION C
, SYS.XSTREAM$_SERVER XS WHERE C.OUTBOUND_SERVER = XS.SERVER_NAME