Peter Ramm

I‘m looking forward to my session at the #doag2025 on Wednesday

Generate synthetic workload on Oracle-DB

In preparation of my session at the #DOAG conference I needed an example DB with significant workload.
Running the TPC-C benchmark with HammerDB was the quick solution.
Here are the steps to do this quite dirty but running:
bit.ly/47PhaIC

Oracle-DB: New SQL Diagnostic Report in rel. 19.28 Oracle-DB: New SQL Diagnostic Report in rel. 19.28 and 23.9

New SQL Diagnostic Report in Oracle 19.28

This 23ai feature is backported to 19.28 now.

bit.ly/46KiUnF

Oracle-DB: Estimate network latency of client connections by evaluation of Active Session History Oracle-DB: Estimate network latency of client connections by evaluation of Active Session History

#Oracle-DB: Estimate network latency of client connections by evaluation of Active Session History

It is always surprising what unexpected insights can still be drawn from the Active Session History.

rammpeter.blogspot.com/2025/01/orac...

Oracle DB: Detect missing use of prepared statements in SQLs Blog with hints and examples for Oracle performance analysis. Especially how to do Oracle performance analysis with my free tool "Panorama".

#Oracle DB: Detect missing use of prepared statements in SQLs

A common disease of many software developers is the ignorance of prepared statements when using SQL.
See how to evaluate the problem in running systems and identify the most critical occurrences of this problem.
bit.ly/3ZrjZLS

Hi Gerald, could you please add me too.