Additional Crash Issues
What happens if system crashes during Analysis? During REDO?
How do you limit the amount of work in REDO?
- Flush asynchronously in the background.
- Watch for “hot spots”.
How do you limit the amount of work in UNDO?
- Avoid long-running Xacts.