What happens under the hood when a commit statement is issued in Oracle 10g?

Question

Suppose the update is done through a transaction, and then a commit statement is issued.

What are all the internal processes that occur under the hood on the Oracle server after the commit statement?

+6

user1841982 Feb 10 '13 at 8:03

3 answers

Donato Szilagyi · Answer 1 · 2013-02-10T08:54:24+0000

SCN (system change number) is incremented: SCN guarantees transaction order
LGWR (Log Writer) writes the remaining re-log to disk
LGWR writes SCN to online redo log files
The transaction is deleted from V $ TRANSACTION
Locks of the current session are released, removed from V $ LOCK
Other sessions waiting to block the actual session are notified
A wipe lock may occur: lock information is cleared from the block headers of the blocks modified by the transaction.

David aldridge · Answer 2 · 2013-02-10T18:04:03+0000

This is a very large subject, but here are some good resources on this:

michelle.ann.diaz · Answer 3 · 2013-02-11T06:23:41+0000