Show TOC

Wait Situations (Exclusive)Locate this document in the navigation structure

Use

In the SQL Locks user menu, you can find (among other things) a display of wait situations for exclusive locks. 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.

Procedure

Open the Database Assistant (transaction DB50) or the liveCache Assistant (transaction LC10). Choose Start of the navigation path Current Status Next navigation step SQL Locks Next navigation step Wait Situations End of the navigation path.

The wait situations display is part of the DBA Cockpit and can therefore also be called as follows:

  1. Open DBA Cockpit (transaction DBACOCKPIT).

  2. The display options in DBA Cockpit vary depending on which SAP NetWeaver release you are using.

    • Choose Start of the navigation path Performance Next navigation step Locks Next navigation step SQL Locks: Wartesituationen End of the navigation path.

    • SAP NetWeaver 7.1: Choose Start of the navigation path Performance Next navigation step SQL Locks Next navigation step  Wait Situations End of the navigation path.

Result

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

Note

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