Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> When does oracle allocate a ora_ROWSCN to a transaction

When does oracle allocate a ora_ROWSCN to a transaction

From: Adi Alurkar <aalurkar_at_linkedin.com>
Date: Fri, 9 Mar 2007 12:13:33 -0800
Message-Id: <95EA4E25-A71E-4100-A86D-F6D3716881AA@linkedin.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US