8.53 V$LOGMNR_LOGS
V$LOGMNR_LOGS
contains log information.
Column | Datatype | Description |
---|---|---|
|
|
This column is deprecated. |
|
|
Name of the log file |
|
|
Oldest date of any records in the file |
|
|
Most recent date of any records in the file |
|
|
Database ID |
|
|
Name of the database |
|
|
Resetlogs SCN of the database incarnation that generated the log file |
|
|
Resetlogs timestamp of the database incarnation that generated the log file |
|
|
The setting of the database COMPATIBLE initialization parameter at the time the log file was generated |
|
|
Thread number |
|
|
Thread sequence number |
|
|
SCN allocated when log switched into |
|
|
SCN after this log. Low SCN of the next log. |
|
|
Indicates whether dictionary dumped to redo logs starts in this redo log ( |
|
|
Indicates whether dictionary dumped to redo logs ends in this redo log ( |
|
|
Redo log file type:
|
|
|
Database block size |
|
|
Size of the redo file (in bytes) |
|
|
Informational message. A value of |
|
|
Status of the redo log file:
|
|
|
The ID of the container to which the data pertains. Possible values include:
|