Martin Berger (berx)
@martinberx.bsky.social
husband & father; performance seeker; Oracle ACE Alumnus; proud member of @SYM_42; Views are my own;
Had a closer look at the implementation of the CURSORTRACE event... and encountered a few surprises: t.ly/jQG6B
Understanding the CURSORTRACE Event
The Oracle library cache is extensively instrumented, but the instrumentation is disabled by default. It can be enabled using the CURSORTRACE event, which is particularly useful for investigating libr...
t.ly
Most database performance issues aren’t caused by hardware. They’re caused by design decisions made years ago.
If this comes true, many sysadmins will have to update their timezone definition files 🌞 House passes bill to make Daylight Saving Time permanent share.google/fSrCR86MYNOR...
House passes bill to make Daylight Saving Time permanent | CNN Politics
The US House voted Tuesday to pass a measure to enact year-round Daylight Saving Time across the country, springing Congress forward into an issue that has long stumped lawmakers and spurred impassion...
share.google
I went a bit OTT with my minimalistic-scripts to create a database. simpleoracledba.blogspot.com/2026/07/draf... But it was Fun to tweak the scripts. I have a few more ideas, notes, suggestions. Maybe Later. First: I have a motorcycle to Ride.
Creating an Oracle 26ai database - Parameters and parameter-files.
TL;DR: The minimum amount of parameters for the init.ora when creating an Oracle 26ai database from scripts. Simple is better: I'll provide ...
simpleoracledba.blogspot.com
Today I visited a museum which started as an art collection 250 years ago. That's really worth celebrating!
bringing the same test down from 39 min to <4 sec. 🥳
@nakdimon.bsky.social helps our SQLs to find pattern in our data with MATCH_RECOGNIZE #AOUG2026 #OracleACE
🇦🇹🚀 The Oracle ACE community is heading to Vienna for the AOUG User Conference 2026! Connect with Oracle experts, discover the latest innovations, and learn from real-world customer experiences. 🙌 🔗 www.aoug.at/Event/668 #OracleACE
This is the last day to submit for EMEA Community Tour 2026. CfP ends TODAY! So head to https://sessionize.com/emea-community-tour-2026# now and submit. @EOUC #OCTEMEA2026 @oracleace See all Events and CfPs on www.clocwise.org.
Only one more day to submit for EMEA Community Tour - CASOUG week CfP ends TOMORROW! Take this final chance to be part of this event and enter your abstract on https://sessionize.com/emea-community-tour-2026. See all Events and CfPs on www.clocwise.org.
playing with Opencode today. it's likely all the files generated can simply be purged, but I learned a LOT about SW development.
with all the new AI integrations ongoing, I soon will need an AI assistant to feed all the AI tools with proper AI skills. once again, I'm the bottleneck. Had this feeling (being the bottleneck) more than 10 yrs ago already, different role, similar context (scale me!) - it seems history repeats?
@ora2know.de heute bei der WAREMA Sun Academy in Wertheim. After Work Event mit Vortägen zusammen mit dem Förderverein der DV Schule Würzburg.
Is AI the new "shadow IT"? (Just hyper-charged by ... well, a hype) In terms of cost, accountability, etc I see some reasons for that argument.
I can say for sure: the best LLM at hand is the one with free tokens/credits left 🤣 With some preparation, I can easily switch from one to the next.
In parallel execution, skew in runtime can be a signal to bad performance due to uneven data distribution. Sometimes it's on purpose and not a data problem at all. Understanding the difference is worth, to avoid wrong tuning approaches. berxblog.blogspot.com/2026/05/sing...
Single Server DFO
a personal blog about most technical, IT related, but sometimes private thoughts.
berxblog.blogspot.com
recently I learned an old feature in Oracles parallel execution: When required, a plan switches to serial execution (done by the QC) and later on back to parallel DFOs. It's there since 12.1! berxblog.blogspot.com/2026/05/back...
Back to Parallel
a personal blog about most technical, IT related, but sometimes private thoughts.
berxblog.blogspot.com
If you don't know who just made their appearance as the #POUG2026's Gold Partner, you should Google (it). Welcome to the POUG family! And buckle up 🙃
note to self: the gv$() function only works with fixed tables ( x$... ). ( In some edge cases a function is also possible, but that should not be used (or usable) for application purpose. berxblog.blogspot.com/2017/04/can-... )
Can I flush the shared pool of all RAC Instances in an Active DataGuard?
a personal blog about most technical, IT related, but sometimes private thoughts.
berxblog.blogspot.com
P99 Conf from @scylladb.com is looking for talks on eBPF 🐝 I've seen quite a few impressive talks there from the likes of Liz Rice, Tanel Poder, and Jose Fernandez. CfP is open until May 29th, let me know if you need help
P99 CONF 2026: Call for Speakers
Are you an engineer obsessed with P99 percentiles and high-performance, low-latency applications? Come share your most interesting approaches for solv...
sessionize.com
Today I developed a Wireless Braking System (WBS). Let's see how technical acceptance tests will perform.
