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...

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...

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

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 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