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

VIEW: SYS.DBA_LOGSTDBY_PROGRESS

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

List the SCN values describing read and apply progress

[View Source]

Columns
Name Datatype Length Mandatory Comments
APPLIED_SCN NUMBER

All transactions with a commit SCN <= this value have been applied
APPLIED_THREAD# NUMBER

Thread number for a log containing the applied_scn
APPLIED_SEQUENCE# NUMBER

Sequence number for a log containing the applied_scn
APPLIED_TIME DATE

Estimate of the time the applied_scn was generated
READ_SCN NUMBER

All log data less than this SCN has been preserved in the database
READ_THREAD# NUMBER

Thread number for a log containing the read_scn
READ_SEQUENCE# NUMBER

Sequence number for a log containing the read_scn
READ_TIME DATE

Estimate of the time the read_scn was generated
NEWEST_SCN NUMBER

The highest SCN that could be applied given the existing logs
NEWEST_THREAD# NUMBER

Thread number for a log containing the newest_scn
NEWEST_SEQUENCE# NUMBER

Sequence number for a log containing the newest_scn
NEWEST_TIME DATE

Estimate of the time the newest_scn was generated
Query Text

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


SELECT APPLIED_SCN
,      APPLIED_THREAD#
,      APPLIED_SEQUENCE#
,      APPLIED_TIME
,      READ_SCN
,      READ_THREAD#
,      READ_SEQUENCE#
,      READ_TIME
,      NEWEST_SCN
,      NEWEST_THREAD#
,      NEWEST_SEQUENCE#
,      NEWEST_TIME
FROM SYS.DBA_LOGSTDBY_PROGRESS;

Dependencies

[top of page]

SYS.DBA_LOGSTDBY_PROGRESS references the following:

SchemaSYS
ViewLOGSTDBY_LOG
SchemaSYSTEM
TableLOGMNR_SESSION$
TableLOGSTDBY$APPLY_MILESTONE
TableLOGSTDBY$PARAMETERS
SYS.DBA_LOGSTDBY_PROGRESS is referenced by following:

SchemaPUBLIC
SynonymDBA_LOGSTDBY_PROGRESS
SchemaSYS
ViewDBA_LOGSTDBY_LOG
Package BodyDBMS_INTERNAL_LOGSTDBY - show dependent code
Package BodyDBMS_LOGSTDBY - show dependent code