Session Explorer: Locks
This page displays information about the selected user session. The Session Info section displays a report for the session.
The Locks tab displays a list of the table and page locks for this user session.
| Lock name | Description | Statement usually placing the lock |
|---|---|---|
| S | Shared lock | SELECT |
| X | Exclusive lock | INSERT, UPDATE, DELETE |
| U | Update lock | SELECT in an update cursor |
| B | Byte lock | Any statement that updates VARCHAR columns |