Oracle-DB: Create trace file for optimizer parse (event 10053) Blog with hints and examples for Oracle performance analysis. Especially how to do Oracle performance analysis with my free tool "Panorama".

Oracle-DB: Quickly get an optimizer trace output (event 10053)
rammpeter.blogspot.com/2026/03/orac...

Oracle-DB: Alternative for AWR and ASH in Standard Edition
The recording of the ODTUG webinar from March 3rd is online now: www.odtug.com/news/panoram...

Tomorrow I‘ll show how the tool Panorama can be used to quickly establish history recording at Oracle SE
www.odtug.com/events/panor...

Oracle-DB: How to evaluate past operation state without Diagnostics Pack
There's a webinar on March 3, 2026, showing the steps to do this.
www.odtug.com/events/panor...

Anti-Zukunftskurs der DIHK stoppen! Die DIHK verbreitet in ihren Pressemeldungen irreführende Informationen über angeblich zu hohe Kosten der Energiewende: "Energiewende oder Energiewende-Politik kostet 5,4 Billionen Euro" heißt es dort...

Ein Wirtschaftsgigant bremst den #Klimaschutz aus: Die #DIHK fordert, dass Deutschland das Ziel der Klimaneutralität bis 2045 abschafft.

Unterzeichne jetzt die WeAct-Petition, um an den DIHK-Präsident zu appellieren. weact.campact.de/petitions/an...

Oracle-DB: Check user-defined PL/SQL functions for missing DETERMINISTIC flag Oracle-DB Performance: Check user-defined PL/SQL functions for missing DETERMINISTIC flag

Why an often underrated DETERMINISTIC flag in PL/SQL functions can result in significant performance losses. How to find the affected SQL statements.

rammpeter.blogspot.com/2026/01/orac...

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.