Lock escalation

Pandora-Box · Posted: Fri Nov 18, 2011 1:45 pm

Hi all,

I have a doubt on Lock escalation which is would frequent commits in the application program reduce the possibility of getting LOCK ESCALATION

I know that lock escalation occurs when the number of locks aquired is greater than what is being defined as the threshold limit.

I too understand that too many commits is an over head too

Please advice.

GuyC · Posted: Fri Nov 18, 2011 5:39 pm

it depends on Isolation level, but yes : "commit" releases locks

Pandora-Box · Posted: Fri Nov 18, 2011 7:59 pm

Thanks Guyc