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.DBA_XSTREAM_INBOUND_PROGRESS

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SERVER_NAME	VARCHAR2	(128)	Yes	Name of the outbound server
PROCESSED_LOW_POSITION	RAW	(64)		Position of processed low transaction
APPLIED_LOW_POSITION	RAW	(64)		All messages with commit position less than this value have been applied
APPLIED_HIGH_POSITION	RAW	(64)		Highest commit position of a transaction that has been applied
SPILL_POSITION	RAW	(64)		Position of the spill low watermark
OLDEST_POSITION	RAW	(64)		Earliest position of the transactions currently being applied
OLDEST_MESSAGE_NUMBER	NUMBER		Yes	Earliest message number of the transactions currently being applied
APPLIED_MESSAGE_NUMBER	NUMBER		Yes	All messages below this number have been successfully applied
APPLIED_TIME	DATE			Time at which the APPLIED_MESSAGE_NUMBER message was applied
APPLIED_MESSAGE_CREATE_TIME	DATE			Time at which the APPLIED_MESSAGE_NUMBER message was created
SPILL_MESSAGE_NUMBER	NUMBER			Spill low water mark SCN
SOURCE_DATABASE	VARCHAR2	(128)		Database where the transaction originated
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
,      PROCESSED_LOW_POSITION
,      APPLIED_LOW_POSITION
,      APPLIED_HIGH_POSITION
,      SPILL_POSITION
,      OLDEST_POSITION
,      OLDEST_MESSAGE_NUMBER
,      APPLIED_MESSAGE_NUMBER
,      APPLIED_TIME
,      APPLIED_MESSAGE_CREATE_TIME
,      SPILL_MESSAGE_NUMBER
,      SOURCE_DATABASE
,      SOURCE_ROOT_NAME
FROM SYS.DBA_XSTREAM_INBOUND_PROGRESS;

Dependencies

[top of page]

SYS.DBA_XSTREAM_INBOUND_PROGRESS references the following:

SYS: STREAMS$_APPLY_PROCESS; XSTREAM$_SERVER; _DBA_APPLY_MILESTONE

SYS.DBA_XSTREAM_INBOUND_PROGRESS is referenced by following:

PUBLIC: DBA_XSTREAM_INBOUND_PROGRESS
SYS: ALL_XSTREAM_INBOUND_PROGRESS