V$FLASHBACK_DATABASE_LOGFILE definition in Oracle Database 11.2
V$FLASHBACK_DATABASE_LOGFILE

select
  NAME,                                    -- NAME VARCHAR2(513)
  LOG#,                                    -- LOG# NUMBER
  THREAD#,                                 -- THREAD# NUMBER
  SEQUENCE#,                               -- SEQUENCE# NUMBER
  BYTES,                                   -- BYTES NUMBER
  FIRST_CHANGE#,                           -- FIRST_CHANGE# NUMBER
  FIRST_TIME                               -- FIRST_TIME DATE
from
  GV$FLASHBACK_DATABASE_LOGFILE
where
  inst_id = USERENV('Instance')

home |  up