Database Architecture   «Prev  Next»

Oracle Redo Log Process

  1. Data blocks are read into memory from disk.
  2. Records are deleted from the blocks in memory.
  3. A record of each deletion is written to the redo log.
  4. A commit record is written to the redo log.
  5. The transaction ends successfully.

The process is the same regardless of whether you are inserting, updating, or deleting data. From a redo log perspective, all of these actions result simply in changes to one or more blocks.