←
Stefan Koehler6,286 posts
Stefan Koehler avatar

Stefan Koehler

@OracleSK

Independent Oracle performance consultant and researcher. Internals geek. OakTable member. Oracle ACE Alum. Sym42.

◷ Joined October 2014▧ 972 Photos and videos
Stefan Koehler avatar
Stefan Koehler@OracleSK·May 11

Rare opportunity to secure guaranteed Oracle Database performance & troubleshooting support Starting from 01 June 2026, I’m opening a limited number of monthly retainer slots for organizations that need reliable Oracle Database expertise without the overhead of a full-time hire.

Post attachment
Stefan Koehler avatar
Stefan Koehler@OracleSK·Nov 15

Liebe 🇩🇪 BTC Plebs, denkt immer daran. Lieber jetzt kaufen und ggf. nochmal kurzfristig -25% hinnehmen, als später irgendwann mal +25% dem deutschen Staat an Steuern abdrücken zu müssen. #Mindset #BTC

Stefan Koehler avatar
Stefan Koehler@OracleSK·Aug 18

Hey @DHLPaket soviele Unfälle oder Krankheiten kann es gar nicht geben - so oft wie ich diese Nachricht hier sehe. Arbeitszeitüberschreitung wäre auch wieder typisch alman, kann es hier aber auch nicht sein (9:25 - 15:58 Uhr). Warum steht beim Grund nicht einfach „Kein Bock“?

Post attachment
Christoph Lutz avatar
⟳ Stefan Koehler retweeted
Christoph Lutz@chris_skyflier·23 Jul 2025

If you've ever felt the need to manually control adaptive lgwr features, this gdb script's got you covered: t.ly/lJIW1 😎 It lets you enable and disable adaptive scalable lgwr, fast log file sync, and log parallelism. Highly experimental, of course! Example 👇

Post attachmentPost attachment
Stefan Koehler avatar
Stefan Koehler@OracleSK·20 Jun 2025

Any reason why the OVA image of the Oracle Database Free 23.x Virtual Appliance is not updated anymore? 23.8 is out for quite a time now but the OVA image is still 23.7 (23.7.0.25.01)? Thank you. @GeraldVenzl

Christoph Lutz avatar
⟳ Stefan Koehler retweeted
Christoph Lutz@chris_skyflier·6 Mar 2025

For geeks: two bpftrace scripts to map UTS event and component names to their internal ids. t.ly/bGj0M t.ly/ypKuv Didn’t plan on it, but sometimes the rabbit hole chooses you... Turns out "oradebug doc" doesn't expose all trace events.

Post attachmentPost attachment
Christoph Lutz avatar
⟳ Stefan Koehler retweeted
Christoph Lutz@chris_skyflier·16 Jan 2025

It continues to amaze me time and again what bpf based tracing makes possible … been looking into Oracle write consistency and update restart mechanics recently and tinkered with a bpftrace script to detect restarts system-wide and in real-time: t.ly/MgyQ- 🤓

Post attachmentPost attachment
Christoph Lutz avatar
⟳ Stefan Koehler retweeted
Christoph Lutz@chris_skyflier·7 Jan 2025

1/4 Interesting UPDATE restart variation: Oracle may try to update a row during the ALL LOCKED phase that wasn't returned and locked in the prior LOCK phase (row 0 in the example).

Post attachment