Oracle DBA FAQ

Oracle RAC interview questions, Oracle Dataguard, ASM, CRS, Oracle wait events, Performance Tuning

    11G - How Does Flashback Data Archive Work?



    11G - How Does Flashback Data Archive Work?

    Post  Edward on Wed Nov 24, 2010 9:45 am

    • Primary source for history is the undo

    • History is stored in automatically
    created history tables inside the

    • Transactions and its undo records on
    tracked tables marked for archival

    • undo records not recycled until history is

    • History is captured asynchronously
    by new background process (fbda)

    • default capture interval is 5 minutes
    • capture interval is self-tuned based on
    system activities
    • process tries to maximize undo data reads
    from buffer cache for better performance
    • INSERTs do not generate history records

      Current date/time is Sun Dec 16, 2018 11:53 pm