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

VIEW: SYS.DBA_XSTREAM_OUTBOUND_PROGRESS

Object Details
Object Name: DBA_XSTREAM_OUTBOUND_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
SOURCE_DATABASE VARCHAR2 (128)
Database where the transaction originated
PROCESSED_LOW_POSITION RAW (64)
Position of low watermark transaction processed by client
PROCESSED_LOW_TIME DATE

Time which the processed low position was last updated
OLDEST_POSITION RAW (64)
Earliest position of the transactions currently being applied
SOURCE_ROOT_NAME VARCHAR2 (128)
Root database where all transactions originated
PROCESSED_LOW_SCN NUMBER
Yes SCN of low watermark transaction processed
OLDEST_SCN NUMBER
Yes Oldest SCN of the transactions currently being applied
Query Text

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


SELECT SERVER_NAME
,      SOURCE_DATABASE
,      PROCESSED_LOW_POSITION
,      PROCESSED_LOW_TIME
,      OLDEST_POSITION
,      SOURCE_ROOT_NAME
,      PROCESSED_LOW_SCN
,      OLDEST_SCN
FROM SYS.DBA_XSTREAM_OUTBOUND_PROGRESS;

Dependencies

[top of page]

SYS.DBA_XSTREAM_OUTBOUND_PROGRESS references the following:

SchemaSYS
ViewDBA_XSTREAM_OUTBOUND
PL/SQL PackageDBMS_LOGREP_UTIL - show dependent code
FunctionGET_MAX_CHECKPOINT
TableSTREAMS$_APPLY_PROCESS
View_DBA_APPLY_MILESTONE
SYS.DBA_XSTREAM_OUTBOUND_PROGRESS is referenced by following:

SchemaPUBLIC
SynonymDBA_XSTREAM_OUTBOUND_PROGRESS
SchemaSYS
ViewALL_XSTREAM_OUTBOUND_PROGRESS