An extremely good read for understanding how Oracle deals with clean/dirty buffer using UNDO tablespace. It’s pretty confusing though!
There is some confusion about the expression “clean” in Oracle circles, so I thought I’d write a short note to explain the different ways in which the word may be applied to Oracle blocks. There are five terms to consider:
- commit cleanout
- block cleanout
- delayed block cleanout
- delayed logging block cleanout
View original post 1,187 more words