V$FLASHBACK_DATABASE_LOGFILE

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
`TYPE`^Foot 1	`VARCHAR2(9)`	Log type: `NORMAL` `RESERVED` `FREE` `TO` `DELETE`

^Footnote 1This column is available starting with Oracle Database 11g Release 2 (11.2.0.2).