eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: SYS.DBA_APPLY_PROGRESS

Object Details

Object Name:	DBA_APPLY_PROGRESS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Information about the progress made by apply process

[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

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

Dependencies

[top of page]

SYS.DBA_APPLY_PROGRESS references the following:

SYS: STREAMS$_APPLY_PROCESS; XSTREAM$_SERVER; _DBA_APPLY_MILESTONE

SYS.DBA_APPLY_PROGRESS is referenced by following:

PUBLIC: DBA_APPLY_PROGRESS
SYS: ALL_APPLY_PROGRESS