Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-12
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

V$LOGMNR_LOGS

V$LOGMNR_LOGS contains log information.

Column Datatype Description
LOG_ID NUMBER This column is deprecated.
FILENAME VARCHAR2(512) Name of the log file
LOW_TIME DATE Oldest date of any records in the file
HIGH_TIME DATE Most recent date of any records in the file
DB_ID NUMBER Database ID
DB_NAME VARCHAR2(8) Name of the database
RESET_SCN NUMBER Resetlogs SCN of the database incarnation that generated the log file
RESET_SCN_TIME DATE Resetlogs timestamp of the database incarnation that generated the log file
COMPATIBLE VARCHAR2(17) The setting of the database COMPATIBLE initialization parameter at the time the log file was generated
THREAD_ID NUMBER Thread number
THREAD_SQN NUMBER Thread sequence number
LOW_SCN NUMBER SCN allocated when log switched into
NEXT_SCN NUMBER SCN after this log. Low SCN of the next log.
DICTIONARY_BEGIN VARCHAR2(3) Indicates whether dictionary dumped to redo logs starts in this redo log (YES) or not (NO)
DICTIONARY_END VARCHAR2(3) Indicates whether dictionary dumped to redo logs ends in this redo log (YES) or not (NO)
TYPE VARCHAR2(7) Redo log file type:
  • ARCHIVED

  • ONLINE

BLOCKSIZE NUMBER Database block size
FILESIZE NUMBER Size of the redo file (in bytes)
INFO VARCHAR2(32) Informational message. A value of MISSING_LOGFILE will be assigned to a row entry where a needed log file is missing from the list of log files.
STATUS NUMBER Status of the redo log file:
  • 0 - Will be read

  • 1 - First to be read

  • 2 - Not needed

  • 4 - Missing log file