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

VIEW: SYS.DBA_LOGSTDBY_LOG

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

List the information about received logs from the primary

[View Source]

Columns
Name Datatype Length Mandatory Comments
THREAD# NUMBER
Yes Redo thread number
RESETLOGS_CHANGE# NUMBER
Yes Start SCN of the branch
RESETLOGS_ID NUMBER
Yes Resetlogs identifier, a numeric form of the timestamp of the branch
SEQUENCE# NUMBER
Yes Redo log sequence number
FIRST_CHANGE# NUMBER
Yes First change# in the archived log
NEXT_CHANGE# NUMBER

First change in the next log
FIRST_TIME DATE

Timestamp of the first change
NEXT_TIME DATE

Timestamp of the next change
FILE_NAME VARCHAR2 (513)
Archived log file name
TIMESTAMP DATE

Time when the archiving completed
DICT_BEGIN VARCHAR2 (3)
Contains beginning of Log Miner Dictionary
DICT_END VARCHAR2 (3)
Contains end of Log Miner Dictionary
APPLIED VARCHAR2 (8)
Indicates apply progress through log stream
BLOCKS NUMBER

Indicates the number of blocks in the log
BLOCK_SIZE NUMBER

Indicates the size of each block in the log
Query Text

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


SELECT THREAD#
,      RESETLOGS_CHANGE#
,      RESETLOGS_ID
,      SEQUENCE#
,      FIRST_CHANGE#
,      NEXT_CHANGE#
,      FIRST_TIME
,      NEXT_TIME
,      FILE_NAME
,      TIMESTAMP
,      DICT_BEGIN
,      DICT_END
,      APPLIED
,      BLOCKS
,      BLOCK_SIZE
FROM SYS.DBA_LOGSTDBY_LOG;

Dependencies

[top of page]

SYS.DBA_LOGSTDBY_LOG references the following:

SchemaSYS
ViewDBA_LOGSTDBY_PROGRESS
SchemaSYSTEM
TableLOGMNR_LOG$
TableLOGSTDBY$PARAMETERS
SYS.DBA_LOGSTDBY_LOG is referenced by following:

SchemaPUBLIC
SynonymDBA_LOGSTDBY_LOG
SchemaSYS
Package BodyDBMS_INTERNAL_LOGSTDBY - show dependent code