When does oracle allocate a ora_ROWSCN to a transaction
- From: Adi Alurkar <aalurkar@xxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 9 Mar 2007 12:13:33 -0800
Greetings,
At what point does Oracle allocate a ora_ROWSCN to a transaction? Is
the ora_ROWSCN allocated when the transaction commences or when it is
committed?
i.e.
transaction T1 starts at 00:00:00 on 01/01/2007 and runs for 10
minutes (ends at 00:09:59 01/01/2007)
transaction T2 starts at 00:02:00 on 01/01/2007 and runs for 4
minutes (ends at 00:06:59 01/01/2007)
transaction T3 starts at 00:04:00 on 01/01/2007 and runs for 3
minutes (end at 00:07:59 01/01/2007)
which of the following are true ?
T1.ora_ROWSCN > T3.ora_ROWSCN and T3.ora_ROWSCN
or
T3.ora_ROWSCN > T2.ora_ROWSCN > T1.ora_ROWSCN
---
Adi Alurkar
aalurkar@xxxxxxxxxxxx
Other related posts:
