Re: Lock requests queued?

From: joel garry <joel-garry_at_home.com>
Date: Wed, 20 Jun 2012 09:19:16 -0700 (PDT)
Message-ID: <59db49a4-54ab-431a-88d4-70cedbdff863_at_wt8g2000pbb.googlegroups.com>



On Jun 20, 7:51 am, Mark D Powell <Mark.Powe..._at_hp.com> 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..

jg

--
_at_home.com is bogus.
http://www.infoworld.com/d/the-industry-standard/catz-denies-committing-oracle-continued-itanium-support-195966
Received on Wed Jun 20 2012 - 11:19:16 CDT

Original text of this message