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')