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_MILESTONE

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
APPLY#	NUMBER		Yes
SOURCE_DB_NAME	VARCHAR2	(128)
OLDEST_SCN	NUMBER		Yes
COMMIT_SCN	NUMBER		Yes
SYNCH_SCN	NUMBER		Yes
EPOCH	NUMBER		Yes
PROCESSED_SCN	NUMBER		Yes
APPLY_TIME	DATE
APPLIED_MESSAGE_CREATE_TIME	DATE
SPARE1	NUMBER
START_SCN	NUMBER
OLDEST_TRANSACTION_ID	VARCHAR2	(128)
SPILL_LWM_SCN	NUMBER
LWM_EXTERNAL_POS	RAW	(64)
SPARE2	NUMBER
SPARE3	VARCHAR2	(4000)
OLDEST_POSITION	RAW	(64)
SPILL_LWM_POSITION	RAW	(64)
PROCESSED_POSITION	RAW	(64)
XOUT_PROCESSED_POSITION	RAW	(64)
XOUT_PROCESSED_CREATE_TIME	DATE
XOUT_PROCESSED_TID	VARCHAR2	(128)
XOUT_PROCESSED_TIME	DATE
APPLIED_HIGH_POSITION	RAW	(64)
OLDEST_CREATE_TIME	DATE
SPILL_LWM_CREATE_TIME	DATE
SPARE4	RAW	(64)
SPARE5	RAW	(64)
SPARE6	DATE
SPARE7	DATE
SOURCE_ROOT_NAME	VARCHAR2	(128)
FLAGS	NUMBER

Query Text

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


SELECT APPLY#
,      SOURCE_DB_NAME
,      OLDEST_SCN
,      COMMIT_SCN
,      SYNCH_SCN
,      EPOCH
,      PROCESSED_SCN
,      APPLY_TIME
,      APPLIED_MESSAGE_CREATE_TIME
,      SPARE1
,      START_SCN
,      OLDEST_TRANSACTION_ID
,      SPILL_LWM_SCN
,      LWM_EXTERNAL_POS
,      SPARE2
,      SPARE3
,      OLDEST_POSITION
,      SPILL_LWM_POSITION
,      PROCESSED_POSITION
,      XOUT_PROCESSED_POSITION
,      XOUT_PROCESSED_CREATE_TIME
,      XOUT_PROCESSED_TID
,      XOUT_PROCESSED_TIME
,      APPLIED_HIGH_POSITION
,      OLDEST_CREATE_TIME
,      SPILL_LWM_CREATE_TIME
,      SPARE4
,      SPARE5
,      SPARE6
,      SPARE7
,      SOURCE_ROOT_NAME
,      FLAGS
FROM SYS._DBA_APPLY_MILESTONE;

Dependencies

[top of page]

SYS._DBA_APPLY_MILESTONE references the following:

SYS: STREAMS$_APPLY_MILESTONE

SYS._DBA_APPLY_MILESTONE is referenced by following:

SYS: DBA_APPLY_PROGRESS; DBA_GG_INBOUND_PROGRESS; DBA_XSTREAM_INBOUND_PROGRESS; DBA_XSTREAM_OUTBOUND_PROGRESS; DBMS_LOGREP_EXP - show dependent code