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_POSITION |
RAW(64) |
|
Earliest position of the transactions currently being applied |
OLDEST_MESSAGE_NUMBER |
NUMBER |
NOT NULL |
Earliest message number of the transactions currently being applied |
APPLIED_MESSAGE_NUMBER |
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_TIME |
DATE |
|
Time at which the message with the message number displayed in the APPLIED_MESSAGE_NUMBER column was applied |
APPLIED_MESSAGE_CREATE_TIME |
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_NUMBER |
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_DATABASE |
VARCHAR2(128) |
NOT NULL |
Database where the transaction originated |
