• 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
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
