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

VIEW: SYS.DBA_GG_INBOUND_PROGRESS

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

[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
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
FROM SYS.DBA_GG_INBOUND_PROGRESS;

Dependencies

[top of page]

SYS.DBA_GG_INBOUND_PROGRESS references the following:

SchemaSYS
TableSTREAMS$_APPLY_PROCESS
PL/SQL PackageUTL_RAW - show dependent code
TableXSTREAM$_SERVER
View_DBA_APPLY_MILESTONE
SYS.DBA_GG_INBOUND_PROGRESS is referenced by following:

SchemaPUBLIC
SynonymDBA_GG_INBOUND_PROGRESS
SchemaSYS
ViewALL_GG_INBOUND_PROGRESS