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." |