GV$FLASHBACK_DATABASE_LOGFILE
select fn.inst_id, -- INST_ID NUMBER fn.fnnam, -- NAME VARCHAR2(513) fle.flelno, -- LOG# NUMBER fle.flethr, -- THREAD# NUMBER fle.fleseq, -- SEQUENCE# NUMBER fle.flenblks -- BYTES NUMBER * fle.flebsz, to_number (fle.flelscn), -- FIRST_CHANGE# NUMBER to_date -- FIRST_TIME DATE (fle.fleltim, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian') from x$kccfn fn, x$kccfle fle where (fn.fntyp = 24) and (fn.fnnum = fle.flefnh) and (fle.fledup != 0)

home |  up  |  mailbox