Re: Serious article on comparison between MS SQL Server 2005 Yukon and Oracle 10g

From: Jared Still <jkstill_at_cybcon.com>
Date: Tue, 23 Nov 2004 00:30:34 -0800
Message-Id: <pan.2004.11.23.08.30.34.100583@cybcon.com>

On Mon, 22 Nov 2004 21:43:42 -0800, DA Morgan wrote:

... netiquette enforced
>> transitory latch to permit the serial counter value to be updated.
>> Suppose TxA rolls back. TxB may still commit (or rollback). Any
>> subsequent transaction TxC will be allocated 1002, regardless of whether
>> TxA or TxB or both rollback. Of course, either TxA or TxB or both may
>> insert multiple records into the table with the serial column, or into
>> any other tables; there are no petty restrictions for having acquired a
>> new serial number.

> 
> A "transitory" latch is still serialization. That is substantially
> different than a cached sequence.

select name
from v$latch
where lower(name) like '%sequence%';  

NAME

---

sequence cache  

1 row selected. Received on Tue Nov 23 2004 - 02:30:34 CST