Oracle DBA FAQ

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


    11G - How Does Flashback Data Archive Work?

    Share

    Edward
    Guest

    11G - How Does Flashback Data Archive Work?

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

    • Primary source for history is the undo
    data

    • History is stored in automatically
    created history tables inside the
    archive

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

    • undo records not recycled until history is
    archived

    • 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 Thu Nov 23, 2017 10:51 pm