Show TOC

SQL Locks: Wait SituationsLocate this document in the navigation structure


The Locks user menu of the DBA Cockpit contains, among other things, a display of wait situations for exclusive locks (exclusive wait situations). Use this analysis in the following situation, for example: You have been monitoring tasks with the task state Vwait in the Task Manager for a longer period.


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


For SAP NetWeaver 7.1, you can access this information through the Wait Situations user menu.


The system displays a list of all current wait situations for SQL locks in the database.


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.

When you encounter SQL locks, be sure to find out which application is causing the locks. Using the Appl.ID in the wait situations display, you can identify the SAP work process that is holding the lock. You can use the Global Work Process Overview (transaction SM66) to get additional information, such as the user and the report. More information can also be found via bottleneck analysis.

More Information

You can also use options provided in the Database Console for further analysis.

Concepts of the Database System, SQL Locks