Transaction to Find Databse Load details of SQL Statements

[Former Member]

Hello,

I have a document from a previous member of the team who has documented the database load statistics of SQL statements in ABAP programs. I am tyring to find out which transaction that was used to obtain these details. I have given an example of the data that is in the document below.

Does anyone know where we can find this information from?

-

---

STAT_NAME

VALUE

VALUE_PER_EXEC

VALUE_PER_ROW

TOTAL_%

-

---

SQL_ID

Start Time

End Time

Module

Executions

Records

Disk Reads

Buffer Gets

Direct Writes

Parse Calls

Sharable Memory (kb)

Hit Ratio (%)	88.16
I/O Time / block (ms)	3.22
Elapsed Time (ms)	14021702	88744.95	3.17	0.46
CPU Time (ms)	629432	3983.75	0.14	0.11
I/O Wait Time (ms)	13452236	85140.74	3.04	1.63
Appl. Wait Time (ms)	0	0.00	0.00	0.00
Conc. Wait Time (ms)	143	0.90	0.00	0.00
Clust. Wait Time (ms)	0	0.00	0.00

-

---

Thanks and Regards,

Reena

[Former Member · Accepted solution]

Hi,

pls check Tx DBACOCKPIT -> Performance -> SQL Statements.

Play around wih the different views that are offered there. Highlight a single statement and press the 'Cache Totals' button. That should give you the infomation mentioned in the report.

Sven

[Former Member · Accepted solution]

Hello Sven,

This is exactly what I was looking for! Thank you.

Regards,

Reena