Skip to main content
What actually internally happened when a commit statement issued in Oracle
- SCN (System Change Number) is incremented: SCN guarantees the order of transactions
- LGWR (Log Writer) writes remaining redo log to disk
- LGWR writes SCN into the online redo log files
- Transaction is removed from V$TRANSACTION
- Locks of the actual session are released, removed from V$LOCK
- Other sessions waiting for the locks of the actual session are notified
- Block clean out may happen: Lock-related information is cleaned out of the block headers of the blocks modified by the transaction
Comments
Post a Comment
Oracle DBA Information