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:
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-195966Received on Wed Jun 20 2012 - 11:19:16 CDT