Oracle® Database Reference 11g Release 2 (11.2) Part Number E10820-02 |
|
|
View PDF |
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 |