Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-12
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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
TYPEFoot 1  VARCHAR2(9) Log type:
  • NORMAL

  • RESERVED

  • FREE

  • TO DELETE


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