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

VIEW: SYS.CDB_LOGSTDBY_PROGRESS

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

List the SCN values describing read and apply progress in all containers

[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
CON_ID NUMBER

container id
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
,      CON_ID
FROM SYS.CDB_LOGSTDBY_PROGRESS;

Dependencies

[top of page]

SYS.CDB_LOGSTDBY_PROGRESS does not reference any database object

SYS.CDB_LOGSTDBY_PROGRESS is referenced by following:

SchemaPUBLIC
SynonymCDB_LOGSTDBY_PROGRESS