What actually internally happened when a commit statement issued in Oracle

What actually internally happened when a commit statement issued in Oracle



  1. SCN (System Change Number) is incremented: SCN guarantees the order of transactions
  2. LGWR (Log Writer) writes remaining redo log to disk
  3. LGWR writes SCN into the online redo log files
  4. Transaction is removed from V$TRANSACTION
  5. Locks of the actual session are released, removed from V$LOCK
  6. Other sessions waiting for the locks of the actual session are notified
  7. Block clean out may happen: Lock-related information is cleaned out of the block headers of the blocks modified by the transaction

Comments