Fantastic article by Jonathan Lewis on why Oracle couldn’t just use REDO to cover the purposes of both UNDO and REDO.
REDO and UNDO – the ‘why’ behind them
February 13, 2010 by tylerv
Posted in General, How Oracle Works | Tagged oracle, redo, undo | Leave a Comment
Leave a Reply Cancel reply
Blogroll
-
Recent Posts
Tags
Categories
- Access / Users (2)
- Baselines / Profiles (1)
- Code (2)
- Collaborate10 (5)
- Dataguard (4)
- Enterprise Manager (2)
- Flashback (1)
- General (5)
- GoldenGate (4)
- How Oracle Works (1)
- Import / Export (2)
- Listener (1)
- Memory (1)
- oracle (1)
- Parallelism (1)
- Performance (2)
- RAC (1)
- rman (2)
- Script (1)
- Script / Automation (3)
- Statistics (1)
- Tracing (1)
- Tuning (1)
- Uncategorized (4)
- unix (4)
- Upgrade (1)
Archives
Top Posts
- Oracle GoldenGate tip: DDL INCLUDE/EXCLUDE and comments
- Data Guard standby redo logs / resizing the primary's redo logs
- See all external directories in Oracle 10g
- Listener queuesize and Solaris tcpip
- Upgrading small databases on big servers (ORA-04031 / 11g)
- Estimating Flashback retention size (FRA)
- Oracle GoldenGate v11 and RMAN-08137
- REDO and UNDO - the 'why' behind them
- ORA-01309: invalid session in dataguard logical standby
- DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE runs and evolves successfully, but errors when returning output (ORA-06502)
Meta