DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.CDB_GG_INBOUND_PROGRESS

Object Details
Object Name: CDB_GG_INBOUND_PROGRESS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
SERVER_NAME VARCHAR2 (128) Yes Name of the outbound server
PROCESSED_LOW_POSITION VARCHAR2 (4000)
Position of 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
OLDEST_POSITION VARCHAR2 (4000)
Earliest position of the transactions currently being applied
APPLIED_LOW_SCN NUMBER
Yes All SCN 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
SOURCE_DATABASE VARCHAR2 (128)
Database where the transaction originated
SOURCE_ROOT_NAME VARCHAR2 (128)
Root database where all transactions originated
LOGBSN VARCHAR2 (4000)
Log BSN value from the GoldenGate trail file
CON_ID NUMBER

container id
Query Text

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
,      APPLIED_LOW_SCN
,      APPLIED_TIME
,      APPLIED_MESSAGE_CREATE_TIME
,      SOURCE_DATABASE
,      SOURCE_ROOT_NAME
,      LOGBSN
,      CON_ID
FROM SYS.CDB_GG_INBOUND_PROGRESS;

Dependencies

[top of page]

SYS.CDB_GG_INBOUND_PROGRESS does not reference any database object

SYS.CDB_GG_INBOUND_PROGRESS is referenced by following:

SchemaPUBLIC
SynonymCDB_GG_INBOUND_PROGRESS