Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Serious article on comparison between MS SQL Server 2005 Yukon and Oracle 10g
"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.comReceived on Tue Nov 23 2004 - 16:44:13 CST