When does oracle allocate a ora_ROWSCN to a transaction

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_at_linkedin.com

--

http://www.freelists.org/webpage/oracle-l Received on Fri Mar 09 2007 - 14:13:33 CST