Escalating a Lock to a Table Lock (Magic xpa 2.x)

In some database systems lock escalation occurs because when many locks are held at one level, the RDBMS automatically changes these locks to a different lock at a higher level (such as a table lock). The number of locks is therefore reduced, but the granularity of what is locked is increased.