last updated: 2026-01-05
Introduction
The article explains the SAP GUI – TCODE (Transaction Code): DBACOCKPIT (Active Statements) usage in details.
SAP GUI
SAP Help Portal – SAP GUI for WindowsSAP Community – SAP GUI – SAP GUI Family147519 – Maintenance strategy / deadlines for SAP GUI for Windows / SAP GUI for Java
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
SAP Help Portal – DBA Cockpit for SAP HANA – Screen Layout in DBA Cockpit for SAP HANA
Screen: Active Statements
Listing the actually running executions.
Example:
Identify long running or resource intensive execution. In the below example we can see all values shows high numbers.
Details (e.g.):
Application SourceAllocated Memory SizeUsed Memory Size (Byte)AVG Execution TimeMAX Execution Timeetc.
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 DateDescription2026.01.05First/initial Release of the SAP Blog Post documentation (Product Information).
last updated: 2026-01-05IntroductionThe article explains the SAP GUI – TCODE (Transaction Code): DBACOCKPIT (Active Statements) usage in details.SAP GUISAP Help Portal – SAP GUI for WindowsSAP Community – SAP GUI – SAP GUI Family147519 – Maintenance strategy / deadlines for SAP GUI for Windows / SAP GUI for JavaDescriptionYou 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 StatementsSAP Help Portal – DBA Cockpit for SAP HANA – Screen Layout in DBA Cockpit for SAP HANAScreen: Active StatementsListing the actually running executions.Example:Identify long running or resource intensive execution. In the below example we can see all values shows high numbers.Details (e.g.):Application SourceAllocated Memory SizeUsed Memory Size (Byte)AVG Execution TimeMAX Execution Timeetc.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 stringOther articles in this series🔖 3428763 – Bookmark of frequently used SAP GUI transaction codes for SAP HANA related investigationsDo 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/guiContributionIf 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 InformationRelease DateDescription2026.01.05First/initial Release of the SAP Blog Post documentation (Product Information). Read More Technology Blog Posts by SAP articles
#SAP
#SAPTechnologyblog
