WHAT IS LOCK ESCALATION?

Mahesh Rawat

Total Post:138

Points:690
Posted by  Mahesh Rawat
 1298  View(s)
Ratings:
Rate this:
  1. Mahesh Rawat

    Post:138

    Points:690
    What is lock escalation?

    When the number of row, page locks held per tablespace 
    exceeds the LOCKMAX value or NUMLKUS or NUMLKTS, the lock
    is escalated to a tablespace lock.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!