| when a SCN is assigned to the transaction? [message #144932] |
Sat, 29 October 2005 01:22  |
contactkeval
Messages: 23
Registered: October 2005
|
Junior Member |
|
|
when a SCN [ system change number ] is assigned to the transaction? is it when the transaction starts or at the time of commit?
<DOC>
When a transaction is committed, the following occurs:
1. The internal transaction table for the associated undo tablespace that the transaction has committed, and the corresponding unique system change number (SCN) of the transaction is assigned and recorded in the table.
2. The log writer process (LGWR) writes redo log entries in the SGA's redo log buffers to the redo log file. It also writes the transaction's SCN to the 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.
</DOC>
source:
http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10743/transact.htm#i8072
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
