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

E40402-10
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_GG_INBOUND_PROGRESS

ALL_GG_INBOUND_PROGRESS displays information about the progress made by the GoldenGate inbound servers accessible to the current user.

Related View

DBA_GG_INBOUND_PROGRESS displays information about the progress made by all GoldenGate inbound servers in the database.

Column Datatype NULL Description
SERVER_NAME VARCHAR2(30) NOT NULL Name of the inbound server
PROCESSED_LOW_POSITION VARCHAR2(4000)   Position of the processed low transaction
APPLIED_LOW_POSITION VARCHAR2(4000)   All messages with commit position less than this value have been applied
APPLIED_HIGH_POSITION VARCHAR2(4000)   Highest commit position of a transaction that has been applied
SPILL_POSITION VARCHAR2(4000)   Position of the spill low watermark of the transactions currently being applied
OLDEST_POSITION VARCHAR2(4000)   Earliest position of the transactions currently being applied
APPLIED_LOW_SCN NUMBER NOT NULL All SCN below or equal to 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
SOURCE_DATABASE VARCHAR2(128) NOT NULL Database where the transaction originated
LOGBSN VARCHAR2(4000)   Log BSN value from the GoldenGate trail file.

Note:

This view is available starting with Oracle Database 11g Release 2 (11.2.0.4).