ALL_XSTREAM_INBOUND_PROGRESS displays information about the progress made by the XStream inbound servers accessible to the current user.
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).
See Also:
"DBA_XSTREAM_INBOUND_PROGRESS"