Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-14
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

ALL_XSTREAM_INBOUND_PROGRESS

ALL_XSTREAM_INBOUND_PROGRESS displays information about the progress made by the XStream inbound servers accessible to the current user.

Related View

DBA_XSTREAM_INBOUND_PROGRESS displays information about the progress made by all XStream inbound servers in the database.

Column Datatype NULL Description
SERVER_NAME VARCHAR2(30) NOT NULL Name of the inbound server
PROCESSED_LOW_POSITION RAW(64)   Position of the processed low transaction
APPLIED_LOW_POSITION RAW(64)   All messages with a 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 of the transactions currently being applied
OLDEST_POSITIONFoot 1  RAW(64)   Earliest position of the transactions currently being applied
OLDEST_MESSAGE_NUMBERFootref 1 NUMBER NOT NULL Earliest message number of the transactions currently being applied
APPLIED_MESSAGE_NUMBERFootref 1 NUMBER NOT NULL Message number up to which all transactions have definitely been applied. This value is the low watermark for the inbound server. That is, messages with a commit message number less than or equal to this message number have definitely been applied, but some messages with a higher commit message number may also have been applied.
APPLIED_TIMEFootref 1 DATE   Time at which the message with the message number displayed in the APPLIED_MESSAGE_NUMBER column was applied
APPLIED_MESSAGE_CREATE_TIMEFootref 1 DATE   Time at which the message with the message number displayed in the APPLIED_MESSAGE_NUMBER column was created at its source database
SPILL_MESSAGE_NUMBERFootref 1 NUMBER   Spill low watermark. Any message with a lower SCN has either been applied or spilled to disk. The XStream client application does not need to send logical change records (LCRs) with a lower SCN than the spill low watermark. Spilled messages may not have been applied yet.
SOURCE_DATABASEFootref 1 VARCHAR2(128) NOT NULL Database where the transaction originated

Footnote 1 This column is available starting with Oracle Database 11g Release 2 (11.2.0.2).