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

VIEW: SYS.DBA_REDO_DB

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
DBID NUMBER
Yes
GLOBAL_DBNAME VARCHAR2 (129)
DBUNAME VARCHAR2 (32)
VERSION VARCHAR2 (32)
THREAD# NUMBER
Yes
RESETLOGS_SCN NUMBER

RESETLOGS_TIME NUMBER
Yes
PRESETLOGS_SCN NUMBER

PRESETLOGS_TIME NUMBER

SEQNO_RCV_CUR NUMBER

SEQNO_RCV_LO NUMBER

SEQNO_RCV_HI NUMBER

SEQNO_DONE_CUR NUMBER

SEQNO_DONE_LO NUMBER

SEQNO_DONE_HI NUMBER

GAP_SEQNO NUMBER

GAP_NEXT_SCN NUMBER

GAP_NEXT_TIME NUMBER

GAP_RET NUMBER

GAP_DONE NUMBER

APPLY_SEQNO NUMBER

APPLY_DONE NUMBER

PURGE_DONE NUMBER

HAS_CHILD NUMBER

ERROR1 NUMBER

STATUS NUMBER

CREATE_DATE DATE

TS1 NUMBER

TS2 NUMBER

TS3 NUMBER

GAP_RET2 NUMBER

CURLOG NUMBER

ENDIAN NUMBER

ENQIDX NUMBER

Query Text

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


SELECT DBID
,      GLOBAL_DBNAME
,      DBUNAME
,      VERSION
,      THREAD#
,      RESETLOGS_SCN
,      RESETLOGS_TIME
,      PRESETLOGS_SCN
,      PRESETLOGS_TIME
,      SEQNO_RCV_CUR
,      SEQNO_RCV_LO
,      SEQNO_RCV_HI
,      SEQNO_DONE_CUR
,      SEQNO_DONE_LO
,      SEQNO_DONE_HI
,      GAP_SEQNO
,      GAP_NEXT_SCN
,      GAP_NEXT_TIME
,      GAP_RET
,      GAP_DONE
,      APPLY_SEQNO
,      APPLY_DONE
,      PURGE_DONE
,      HAS_CHILD
,      ERROR1
,      STATUS
,      CREATE_DATE
,      TS1
,      TS2
,      TS3
,      GAP_RET2
,      CURLOG
,      ENDIAN
,      ENQIDX
FROM SYS.DBA_REDO_DB;

Dependencies

[top of page]

SYS.DBA_REDO_DB references the following:

SchemaSYSTEM
TableREDO_DB
SYS.DBA_REDO_DB is referenced by following:

SchemaPUBLIC
SynonymDBA_REDO_DB