In the SQL Locks user menu, you can find a display of the SQL locks and SQL lock requests.
Open the Database Assistant (transaction DB50) or the liveCache Assistant (transaction LC10). Choose .
or
Open the DBA Cockpit and choose
.The system displays detailed information about the locks currently set. This display can be very long in a running SAP system. Therefore, you should always enter the analysis of SQL locks through the overview of wait situations.
DBA Cockpit: SAP MaxDB, Overview of SQL Locks