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

VIEW: SYS.CDB_APPLY_PROGRESS

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

Information about the progress made by apply process in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
APPLY_NAME VARCHAR2 (128) Yes Name of the apply process
SOURCE_DATABASE VARCHAR2 (128)
Applying messages originating from this database
APPLIED_MESSAGE_NUMBER NUMBER
Yes All messages before this number have been successfully applied
OLDEST_MESSAGE_NUMBER NUMBER
Yes Earliest commit number of the transactions currently being applied
APPLY_TIME DATE

Time at which the message was applied
APPLIED_MESSAGE_CREATE_TIME DATE

Time at which the message to be applied was created
OLDEST_TRANSACTION_ID VARCHAR2 (128)
Earliest transaction id currently being applied
SPILL_MESSAGE_NUMBER NUMBER

Spill low water mark SCN
SOURCE_ROOT_NAME VARCHAR2 (128)
Global name of the source root database
CON_ID NUMBER

container id
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT APPLY_NAME
,      SOURCE_DATABASE
,      APPLIED_MESSAGE_NUMBER
,      OLDEST_MESSAGE_NUMBER
,      APPLY_TIME
,      APPLIED_MESSAGE_CREATE_TIME
,      OLDEST_TRANSACTION_ID
,      SPILL_MESSAGE_NUMBER
,      SOURCE_ROOT_NAME
,      CON_ID
FROM SYS.CDB_APPLY_PROGRESS;

Dependencies

[top of page]

SYS.CDB_APPLY_PROGRESS does not reference any database object

SYS.CDB_APPLY_PROGRESS is referenced by following:

SchemaPUBLIC
SynonymCDB_APPLY_PROGRESS