[Home] [Help] [Dependency Information]
Object Name: | ALL_XSTREAM_INBOUND_PROGRESS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
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 |
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.ALL_XSTREAM_INBOUND_PROGRESS;
|
|
|