Displaying Locks and Lock Requests 
Displaying Locks and Lock Requests
Use
You are given information about the current locks and lock requests in the database server.
Procedure
Choose Instance ® Information ® Locks.
The following information is displayed:
|
Max Entries |
Maximum number of locks held and requested |
|
Average Used Entries |
Average number of locks held and requested |
|
Collisions |
Number of collisions that occurred |
|
Escalations |
Number of escalations that occurred |
|
Row Locks |
Row locks currently held |
|
Table Locks |
Table locks currently held |
|
Request Timeout |
This indicates the time a task may wait for the setting of a requested lock before it is canceled. |