| commit [message #61352] |
Fri, 16 April 2004 00:25  |
siva
Messages: 58
Registered: August 1999
|
Member |
|
|
Hello,
Can anyone help me in telling the steps after commit is issued.WHat happens internally(step by step) after commit, update is given.
Regards
Siva
|
|
|
|
| Re: commit [message #61355 is a reply to message #61352] |
Fri, 16 April 2004 01:33  |
Ulrich
Messages: 1
Registered: April 2004
|
Junior Member |
|
|
Hello Siva,
1. The internal transaction table for the associated rollback segment records that the transaction has commited, and the corrosponding unique system change number (SCN) of the transaction is assigned and recorde in the table.
2.The log writer process (LGWR) writes log entries in the SGA's redo log buffers to the online redo log file. It also writes the transaction's SCN to the online redo log file. This atomic event constitutes the commit of the transaction.
3. Oracle releases locks held on rows and tables.
4. Oracle marks the transaction complete.
Somewhat later the database writer (DBWR) writes the new blockinformation down to file.
Thats it.
regards
Ulrich
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
