LOG_ID
|
NUMBER
|
Identifies the log file.
|
FILENAME
|
VARCHAR2(513)
|
The filename
|
LOW_TIME
|
DATE
|
The oldest date of any records in the file
|
HIGH_TIME
|
DATE
|
The most recent date of any records in the file
|
DB_ID
|
NUMBER
|
The database ID
|
DB_NAME
|
VARCHAR2(8)
|
The name of the database
|
RESET_SCN
|
NUMBER
|
The reset log SCN when the log was created
|
RESET_SCN_TIME
|
NUMBER
|
The time when the reset log SCN was obtained to create the log
|
THREAD_ID
|
NUMBER
|
The thread number
|
THREAD_SQN
|
NUMBER
|
The 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.
|