V$FLASHBACK_DATABASE_LOGFILE displays information about the flashback log files.
| Column | Datatype | Description |
|---|---|---|
NAME |
VARCHAR2(513) |
Name of the log file |
LOG# |
NUMBER |
Log file number |
THREAD# |
NUMBER |
Log file thread number |
SEQUENCE# |
NUMBER |
Log file sequence number |
BYTES |
NUMBER |
Log file size (in bytes) |
FIRST_CHANGE# |
NUMBER |
Lowest system change number (SCN) in the log file |
FIRST_TIME |
DATE |
Time of the first SCN in the log file |