Peter Ramm
@rammpeter.bsky.social
Application developer, ♠️Oracle Ace Associate, Creator of Panorama for Oracle, Working for efficient DB usage by apps, Living near Dresden in Germany
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
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: Run TPC benchmark with hammerdb on Standard Edition
Blog with hints and examples for Oracle performance analysis.
Especially how to do Oracle performance analysis with my free tool "Panorama".
rammpeter.blogspot.com
November 12, 2025 at 9:28 AM
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
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
New SQL Diagnostic Report in Oracle 19.28
This 23ai feature is backported to 19.28 now.
bit.ly/46KiUnF
This 23ai feature is backported to 19.28 now.
bit.ly/46KiUnF
Oracle-DB: New SQL Diagnostic Report in rel. 19.28
Oracle-DB: New SQL Diagnostic Report in rel. 19.28 and 23.9
bit.ly
August 9, 2025 at 2:06 PM
New SQL Diagnostic Report in Oracle 19.28
This 23ai feature is backported to 19.28 now.
bit.ly/46KiUnF
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
It is always surprising what unexpected insights can still be drawn from the Active Session History.
rammpeter.blogspot.com/2025/01/orac...
It is always surprising what unexpected insights can still be drawn from the Active Session History.
rammpeter.blogspot.com/2025/01/orac...
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
rammpeter.blogspot.com
February 19, 2025 at 8:35 PM
#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...
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
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
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
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".
rammpeter.blogspot.com
December 6, 2024 at 8:01 PM
#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
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