Calculate transaction time for TPROC-C workload

[Ora-DBA]

Hi,
I'm performing test for TPROC-C workload. Test got executed successfully and got result of NOPM, TPM values. Is there any way we can track/calculate each transaction time (or time taken for single transaction) and what actual transaction or query or how much data is written to disk?

HammerDB: 4.8
Workload: TPROC-C (OLTP), 100000 transaction per user, 1 VU, 5 min time
DB server: Oracle 19c
DB client: 19.3

Thanks!

[sm-shaw]

Yes you can use time profiling as described here https://www.hammerdb.com/docs/ch04s07.html#d0e2189 by selecting the Time Profile check-box - also if you use the webservice to view your results it will automatically graph them for you: