View Single Post

   
  #5 (permalink)  
Old 02-26-2008, 06:57 PM
xixi
 
Posts: n/a
Default Re: why lock escalation happened

i agree, and so why the lock escalated?

"Mark A" <ma@switchboard.net> wrote in message news:<rhrmc.3$i37.9524@news.uswest.net>...
> > Lock escalation occurs when the TOTAL number of locks held by ALL
> > applications exceeds MAXLOCKS percent of the lock list.
> > <snip>
> > --
> > Matt Emmerton
> >

> That differs from what the Administration Guide: Performance says:
>
> "When the number of locks held by any one application reaches this
> percentage [defined in maxlocks] of the total lock list size, lock
> escalation will occur for the locks held by that application. Lock
> escalation also occurs if the lock list runs out of space."

Reply With Quote