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

Home -> Community -> Usenet -> c.d.o.server -> Re: Serious article on comparison between MS SQL Server 2005 Yukon and Oracle 10g

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

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Tue, 23 Nov 2004 22:44:13 -0000
Message-ID: <41a3bd3d$0$2264$cc9e4d1f@news-text.dial.pipex.com>


"DA Morgan" <damorgan_at_x.washington.edu> wrote in message news:1101188533.245859_at_yasure...
> A "transitory" latch is still serialization. That is substantially
> different than a cached sequence.

How? Oracle uses latching for sequences as well, and for the same reason. I guess one *might* be able to guarantee uniqueness by generating GUIDS based on session,timestamp and maybe some client info, but you aint going to get a 'nice' artificial incrementing key out of it.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com 
Received on Tue Nov 23 2004 - 16:44:13 CST

Original text of this message

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