LOG_ID |
NUMBER |
Identifies the log file. The value of this field is also reported in the LOG_ID column of the V$LOG |
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 |