Re: Dealing with locking in bulk update scenario

From: Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com>
Date: Tue, 2 Nov 2010 11:43:13 +0100
Message-ID: <4CCFEB41.8080709_at_nordea.com>



Grzegorz Goryszewski pisze:
>> Rohit
>>
>>
>> You then need a mechanism to identify rows that weren't updated, and to
>> ensure they are (eventually) correctly processed. Remiguisz'
>> suggestion of
>> ORA_ROWSCN is an even more reliable indicator that something has
>> changed -
>> but in some cases you can be more optimistic (you may only care if a
>> subset
>> of columns is updated)
>>

> Actually ora_rowscn is not as good as it seems to be: > http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:2680538100346782134

reading new editions is usually better than reading the old ones ;-)

-- 
Pole nakazi

----------------------------------------------------------------------
Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com>
pos   : DBA at DIiUSI
addr  : Nordea Bank Polska SA, Luzycka 6A Street, 81-537 Gdynia, Poland
phone : +48 58 667 17 43
mobile: +48 602 42 42 77

Nordea Bank Polska S.A. z siedzib? w Gdyni, ul. Kielecka 2, 81-303 Gdynia, 
wpisan? do Rejestru Przedsi?biorców Krajowego Rejestru S?dowego pod numerem: 0000021828, 
dla której dokumentacj? przechowuje S?d Rejonowy Gda?sk - Pó?noc w Gda?sku, 
VIII Wydzia? Gospodarczy Krajowego Rejestru S?dowego, 
o kapitale zak?adowym i wp?aconym w wysoko?ci: 227.593.500,00 z?otych, 
NIP: 586-000-78-20, REGON: 190024711
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Nov 02 2010 - 05:43:13 CDT

Original text of this message