Show TOC

LocksLocate this document in the navigation structure


The Performance user menu of the DBA Cockpit contains, among other things, a display of all active and required locks. Exclusive locks mean that other users cannot access the locked entry. These locks can significantly interfere with the performance of the SAP system and the database system.


Open the DBA Cockpit (transaction DBACOCKPIT) and choose Start of the navigation path Performance Next navigation step Locks End of the navigation path.


For SAP NetWeaver 7.1, you can access this information through the SQL Locks user menu.


The following user menus are available:

Determining the User Who Triggered a Lock

In a database belonging to an SAP system, the name of a standard user could be SAPR3. You can use the Task Manager to find the task ID (ID) and the corresponding application PID and application server.

Then use the Process Overview (transaction code SM50) or the Application Server Overview (transaction code SM51) to find out which SAP work process triggered the lock request or lock.

More Information

Definitions of the System Tables, LOCKS

Concepts of the Database System, SQL Locks