More on Redo Pass

• Dirty page table details

  • dirty page table from end of analysis pass (restart dirty page table) is used and set in redo pass (and later in undo pass)

• Optimizations of redo

  • Dirty page table info can be used to pre-read pages during redo
  • Out of order redo is also possible to reduce disk seeks

Notes: