Re: Large set-based UPDATE

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Wed, 12 Feb 2003 21:19:08 -0800
Message-ID: <3E4B2ACC.E7D34368@exesolutions.com>

"Howard J. Rogers" wrote:

> On Wed, 12 Feb 2003 06:53:56 +0000, Sybrand Bakker wrote:
>
> >
> >
> >
> > As you are not issuing SELECT FOR updates, or issuing an explicit LOCK
> > TABLE in row share mode, your lock will automatically escalate to a table
> > level lock.
>
> Er, I might be missing the point here, but Oracle doesn't do lock
> escalation a la SQL Server. Which I know you know, so what point am I
> missng here?
>
> Regards
> HJR
Glad you already asked because I was thinking the same thing. Oracle doesn't escalate locks.

Sybrand ... please help us out here.

Daniel Morgan Received on Wed Feb 12 2003 - 23:19:08 CST