Chris Antognini
@chris.antognini.ch
Striving for Optimal Performance https://antognini.ch
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
This is news about a legend that I completely missed! Fortunately, @economist.com filled that gap.
The Economist@economist.com · 3w agoFlying in any form was Wally Funk’s life; she breathed it and ate it. She never married because she was married to planes. We remember her life
If you want to know how the new JOIN TO ONE syntax can help to reduce complexity of SQL queries and avoid incorrect results in star schemas, read my lastest blog post: danischnider.wordpress.com/2026/07/18/j...
JOIN TO ONE and Star Schemas
Oracle’s new JOIN TO ONE syntax offers several benefits for queries in star schemas. Let’s take a look at some typical use cases involving facts and dimensions, and see how the new join option can …
danischnider.wordpress.com
Critics of AI complain when models make up confident-sounding but factually incorrect answers. When there is no factually correct answer, however, AI’s shortcomings can be even more pronounced and less easy to detect
AI models’ values are very different from most people’s
They are more secular and more liberal—unless they’re made in China
econ.st
Oracle provides an APEXlang compiler, but not a public parser for building custom tooling. Grisselbav’s APEXlang Parser fills that gap. In this blog post, I show how it enables static code analysis by detecting a security vulnerability in an Oracle APEX app. www.salvis.com/blog/2026/06...
Detecting Security Vulnerabilities With the APEXlang Parser
Introduction A parser for the APEXlang grammar enables the development of tools beyond the scope of the APEXlang compiler included in SQLcl, SQL Developer for VS Code, and ORDS. These tools can perfor...
salvis.com
The perfect guide to the oracle optimizer blogs.oracle.com/optimizer/or... Kudos @vldbb.bsky.social
blogs.oracle.com
New video! For 99% of databases and 99% of the time, the default settings for the optimizer will be fine for your performance needs. But occasionally, you might need to divert to get the most out of it. youtu.be/hm3O7hgup4g
Taking back control of optimizer statistics
YouTube video by SQL and Database explained!
youtu.be
Settler crimes against Palestinians in the West Bank are “not just personal tragedies”, laments Nimrod Novik. They also undermine “Israel’s security, its moral fabric and its international standing”
In the West Bank, Israeli terror begets Palestinian terror
Settler violence undermines Israel’s security, its moral fabric and its global standing, argues Nimrod Novik
econ.st
Israel’s defenders argue rightly that the Middle East has no simple diplomatic solutions. But the country’s overwhelming military superiority is not a solution in itself
The high price of forever wars
Binyamin Netanyahu is quick to start conflicts, but shows no ability to end them
econ.st
I've been busy in the last months! Announcing a brand new "Practical Exadata Performance" training course! I'm not aware of any other training *like this* offered in the world. 😎 Also, a *free* seminar! Exadata is an awesome platform, if used right! learn.tanelpoder.com
We couldn't have done it without her.💐
youtube.com/watch?v=mD1g... My favorites: #10 and #1. But all are spot on.
10 Relational Database Mistakes, Ranked
YouTube video by Decomplexify
youtube.com
Reasons why SELECT * is bad for SQL performance: An old blog (with Oracle-specific examples) with a whole range of reasons why. It's not only about network traffic and SQL plan execution, but client side processing and memory usage as well. tanelpoder.com/posts/reason...
IMO that's good news! Bitcoin mining is no longer profitable after crypto's latest downward turn, analyst says www.cnbc.com/2026/02/24/b...
Bitcoin mining is no longer profitable after crypto's latest downward turn, analyst says
Bitcoin briefly sank below $63,000 on Tuesday, dragging down its miners alongside it.
cnbc.com
Am I the only one who cannot activate SQL History at the session level in #OracleDatabase 26ai? The "ALTER SESSION SET SQL_HISTORY_ENABLED = TRUE" command runs successfully but has no effect...
After a decade of planning, editing, delays due to my own busyness, further editing and waiting for 23c, the release of 26ai and my pre-retirement finally unblocked the situation. I have agreed with Apress to publish the third edition of Troubleshooting Oracle Performance in 2026. #TOP3
From what I see, #OracleDatabase between version 23.3 and version 23.26.1 ships with a buggy TRCSESS script. To fix it, just correctly set the variable JDK_HOME at line 54. I seems that the problem was introduced by the change "adadhich 04/12/23 - use s_jdkLocation".
This is an interesting case of censorship. The two images show the front covers of the same book. One was printed in Switzerland and the other by Amazon. I suppose Donald's ego is just too fragile.
The journey that began with Trivadis in 1999 ends today. It has been a great and memorable one. I had the chance to make so many positive experiences and meet great people inside and outside the company. But it's time for me to move on and enable pre-retirement mode.
I’m a simple man. While Oracle people are ecstatic about ASSERTION in the just released version 23.26.1 of the Oracle Database, I’m happy to see something as simple as FILTER :) 🧵
“Venezuela needs a civilian government constrained by law, respectful of individual freedoms, accountable to voters and capable of rebuilding institutions,” Ricardo Hausmann writes in a guest essay. “Donald Trump appears not to understand this”
Peace and prosperity in Venezuela will come from democracy, not oil, writes Ricardo Hausmann
Wishing otherwise, as Donald Trump does, is delusional
econ.st
Trump attacca il Venezuela, rapisce il capo di stato. Non posso più stare zitto. attivissimo.me/2026/01/03/t...
In 2025 the energy balance of our PV system (10 kWp) improved thanks to better weather (+780 kW) and some adjustments of pool and EV consumption. The self-consumption of 56% is good and could be taken to 60% with further optimisation. Unfortunately, I wasn't able to acquire a V2H wallbox... WIP.
Running a giant software business used to be fun. Artificial intelligence is now turning that model on its head. Nowhere has the transition been as unsettling as at Oracle
Oracle and the hard truths about software
Running a giant digital business is not as fun as it used to be
econ.st
Another observation about MOS: some "migrated" notes are available but empty. Two examples: KB850150 and KB826614. What a mess!
I just noticed that "Previous Favorites" are now available in my MOS account. That said, the list doesn't contain everything I was expecting...
