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

VIEW: SYS.DBA_REDO_LOG

Object Details
Object Name: DBA_REDO_LOG
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

SEQUENCE# NUMBER
Yes
DUPID NUMBER

LOG_TYPE NUMBER

LOG_STATE NUMBER

CREATE_TIME VARCHAR2 (32)
CLOSE_TIME VARCHAR2 (32)
DONE_TIME VARCHAR2 (32)
FIRST_SCN NUMBER

FIRST_TIME NUMBER

NEXT_SCN NUMBER

NEXT_TIME NUMBER

BLOCKS NUMBER

BLOCK_SIZE NUMBER

CREATE_DATE DATE

ERROR1 NUMBER

ERROR2 NUMBER

FILENAME VARCHAR2 (513)
TS1 NUMBER

TS2 NUMBER

TS3 NUMBER

ENDIAN NUMBER

OLD_BLOCKS NUMBER

OLD_LOG_TYPE NUMBER

OLD_LOG_STATE NUMBER

OLD_FILENAME VARCHAR2 (513)
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
,      SEQUENCE#
,      DUPID
,      LOG_TYPE
,      LOG_STATE
,      CREATE_TIME
,      CLOSE_TIME
,      DONE_TIME
,      FIRST_SCN
,      FIRST_TIME
,      NEXT_SCN
,      NEXT_TIME
,      BLOCKS
,      BLOCK_SIZE
,      CREATE_DATE
,      ERROR1
,      ERROR2
,      FILENAME
,      TS1
,      TS2
,      TS3
,      ENDIAN
,      OLD_BLOCKS
,      OLD_LOG_TYPE
,      OLD_LOG_STATE
,      OLD_FILENAME
FROM SYS.DBA_REDO_LOG;

Dependencies

[top of page]

SYS.DBA_REDO_LOG references the following:

SchemaSYSTEM
TableREDO_LOG
SYS.DBA_REDO_LOG is referenced by following:

SchemaPUBLIC
SynonymDBA_REDO_LOG