Re: Lock requests queued?

From: joel garry <>
Date: Wed, 20 Jun 2012 09:19:16 -0700 (PDT)
Message-ID: <>

On Jun 20, 7:51 am, Mark D Powell <> wrote:
> On Tuesday, June 19, 2012 7:05:54 PM UTC-4, joel garry wrote:

> "Oracle uses lock escalation"  Since when?  In SQL Server if you take too many row locks in a block SQL Server will upgrade the row locks to a page lock and if you get too many page locks in the table the page locks are upgraded to a table lock, but Oracle does not do this.  In fact the modern versions of SQL Server pretty avoid doing this.
> HTH -- Mark D Powell --

Oh man, I did get that exactly backwards. I can only plead for mercy because of the crazy db-blind 4GL code I'm working on..


-- is bogus.
Received on Wed Jun 20 2012 - 11:19:16 CDT

Original text of this message