eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.ALL_XSTREAM_OUTBOUND

Object Details

Object Name:	ALL_XSTREAM_OUTBOUND
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Details about the XStream outbound server visible to user

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SERVER_NAME	VARCHAR2	(128)	Yes	Name of the outbound server
CONNECT_USER	VARCHAR2	(30)		Name of the user who can process the outbound LCR stream
CAPTURE_NAME	VARCHAR2	(128)		Name of the XStream capture process
SOURCE_DATABASE	VARCHAR2	(128)		Database where the transaction originated
CAPTURE_USER	VARCHAR2	(128)		Current user who is enqueuing captured messages
QUEUE_OWNER	VARCHAR2	(128)	Yes	Owner of the queue associated with the outbound server
QUEUE_NAME	VARCHAR2	(128)	Yes	Name of the queue associated with the outbound server
USER_COMMENT	VARCHAR2	(4000)		User comment
CREATE_DATE	TIMESTAMP(6)	(11)		Date when outbound server was created
STATUS	VARCHAR2	(8)		Status of the apply process: DISABLED, ABORTED, DETACHED, ATTACHED
COMMITTED_DATA_ONLY	VARCHAR2	(3)		Is outbound server sending committed data only?
START_SCN	NUMBER			Start SCN of the associated co-located capture process
START_TIME	DATE			Start time of the associated co-located capture process
SOURCE_ROOT_NAME	VARCHAR2	(128)		Root database where all transactions originated

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SERVER_NAME
,      CONNECT_USER
,      CAPTURE_NAME
,      SOURCE_DATABASE
,      CAPTURE_USER
,      QUEUE_OWNER
,      QUEUE_NAME
,      USER_COMMENT
,      CREATE_DATE
,      STATUS
,      COMMITTED_DATA_ONLY
,      START_SCN
,      START_TIME
,      SOURCE_ROOT_NAME
FROM SYS.ALL_XSTREAM_OUTBOUND;

Dependencies

[top of page]

SYS.ALL_XSTREAM_OUTBOUND references the following:

SYS: ALL_APPLY; DBA_XSTREAM_OUTBOUND; DBMS_LOGREP_UTIL - show dependent code; GET_MAX_CHECKPOINT

SYS.ALL_XSTREAM_OUTBOUND is referenced by following:

PUBLIC: ALL_XSTREAM_OUTBOUND
SYS: DBMS_CAPTURE_ADM_IVK - show dependent code; DBMS_XSTREAM_UTL_IVK - show dependent code