Re: Migrating from 6.5 SQL Server to Oracle 8.1

From: Pablo Sanchez <pablo_at_dev.null>
Date: Tue, 11 Feb 2003 09:53:27 -0600
Message-ID: <Xns931F5A717E12Epingottpingottbah@216.166.71.233>

DA Morgan <damorgan_at_exesolutions.com> wrote in news:3E48B24D.FA60962E_at_exesolutions.com:

> Your misunderstanding is, how shall I say this kindly, considerable.

I think the follow-on posts clearly states who is misunderstanding what ...

> But please lets not start some stupid flame war here. The point was
> that they are different. Nothing more!

Absolutely. And I pointed out that you can't get something for nothing. Oracle's Lock Manager insists on writing data on a SELECT FOR UPDATE.
> And should you decide to start some flame war count me out ... I'll
> not be suckered in.

Not sure where that's coming from but sure, I'm just pointing out the potential downsides to what you wrote:

3. Oracle has unlimited row level locks and not concept of pages or

lock escallation.

-- 
Pablo Sanchez, High-Performance Database Engineering
http://www.hpdbe.com

Received on Tue Feb 11 2003 - 09:53:27 CST