LOG_ID

NUMBER

Log file identifier

FILENAME

VARCHAR2(513)

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

Reset log SCN when the log was created

RESET_SCN_TIME

DATE

Time when the reset log SCN was obtained to create the log

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.

INFO

VARCHAR2(32)

Informational message. A value of MISSING_LOGFILE will be assigned to a row entry where a needed logfile is missing from the list of log files.

STATUS

NUMBER

Indicates the status of a logfile. A NULL value indicates a valid logfile; a non-NULL value indicates further information is contained in the INFO column as a text string. All logfiles successfully added to the file list will have a status value of NULL.