Technology Blog Posts by SAP
cancel
Showing results for 
Search instead for 
Did you mean: 
Laszlo_Thoma
Product and Topic Expert
Product and Topic Expert
1,133

SAP_Community_2026_Content_Banner_.png

last updated: 2026-01-05

Introduction
The article explains the SAP GUI – TCODE (Transaction Code): DBACOCKPIT (Active Statements) usage in details.

SAP GUI

Description
You can check the "Active Statements" and based on the presented details e.g. long running or resource intensive execution can be identified.

Transaction Code:
DBACOCKPIT 

DBA Cockpit menu structure (Navigation Panel):
Performance > Active Statements

Screen: Active Statements
Listing the actually running executions.

Active_Statements_1.png

Example:
Identify long running or resource intensive execution. In the below example we can see all values shows high numbers.

Details (e.g.):

  • Application Source
  • Allocated Memory Size
  • Used Memory Size (Byte)
  • AVG Execution Time
  • MAX Execution Time
  • etc.

Active_Statements_2.png

The identified statement can be investigated further (ST04 - - > Performance - - > SQL Plan Cache menu and find the SQL statement hash based on the SQL statement string).

Reference:

  • 3322936 - How to find the SQL statement hash for a SQL statement string

Other articles in this series
🔖 3428763 - Bookmark of frequently used SAP GUI transaction codes for SAP HANA related investigations

Do you have further questions?
Please do not hesitate to contact me if you have question or observation regarding the article.
SAP Community for SAP GUI: https://community.sap.com/topics/gui

Contribution
If you find any missing information belongs to the topic, please let me know. I am happy to add the new content. My intention is to maintain the content continuously to keep the info up-to-date.

Release Information

Release DateDescription
2026.01.05First/initial Release of the SAP Blog Post documentation (Product Information).