iiinova — where your digital self keeps evolving

Reposted by Chris Antognini

alacourb.bsky.social @alacourb.bsky.social · 02/10/2026

Looking forward for the next edition of @chris.antognini.ch book after his presentation at @soug.ch day in Zurich #besharing

031

Reposted by Chris Antognini

Dani Schnider @danischnider.bsky.social · 02/10/2026

Good idea for a Christmas gift: @chris.antognini.ch’s third edition of “Trobleshooting Oracle Performance” will be published on 21 December

081

Chris Antognini @chris.antognini.ch · 13/08/2026

At least the temperature is decent at night. This summer, we already had over 50 nights with temperatures higher than 20°. Of course, that's a new record.

100

Chris Antognini @chris.antognini.ch · 25/07/2026

This is news about a legend that I completely missed! Fortunately, @economist.com filled that gap.

000

Reposted by Chris Antognini

Dani Schnider @danischnider.bsky.social · 19/07/2026

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

danischnider.wordpress.com

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 …

122

Chris Antognini @chris.antognini.ch · 15/07/2026

Given how often you attend conferences, the probability is fairly high...

130

Reposted by Chris Antognini

The Economist @economist.com · 30/06/2026

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

econ.st

AI models’ values are very different from most people’s

They are more secular and more liberal—unless they’re made in China

095

Reposted by Chris Antognini

Philipp Salvisberg @salvis.com · 29/06/2026

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

salvis.com

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

041

Reposted by Chris Antognini

Connor McDonald on Database and SQL @connormcd.bsky.social · 17/06/2026

The perfect guide to the oracle optimizer blogs.oracle.com/optimizer/or... Kudos @vldbb.bsky.social

blogs.oracle.com

063

Chris Antognini @chris.antognini.ch · 15/06/2026

FWIW, I don't remember hearing anything specific about it after it was presented.

010

Reposted by Chris Antognini

Connor McDonald on Database and SQL @connormcd.bsky.social · 08/06/2026

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

youtu.be

Taking back control of optimizer statistics

YouTube video by SQL and Database explained!

131

Reposted by Chris Antognini

The Economist @economist.com · 15/05/2026

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”

econ.st

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

0135

Chris Antognini @chris.antognini.ch · 07/05/2026

Thanks. Good to know. It means I can keep the reference about it in TOP3.

010

Chris Antognini @chris.antognini.ch · 07/05/2026

According to my notes, the issue related to the (re)build of indexes is tracked with bug# 28292026. Unfortunately, I don't see it in MOS. I wonder whether it's still considered a bug... any comment @vldbb.bsky.social ?

320

Chris Antognini @chris.antognini.ch · 30/04/2026

Mine was accepted, too. I'm looking forward to my first POUG! See you there.

180

Chris Antognini @chris.antognini.ch · 30/04/2026

As an off-topic note, although the SQL Analysis Report is a version 23 feature, the SQL Analysis table is displayed as of version 21. So, I wonder what information the SQL Analysis table can display in version 21.

010

Chris Antognini @chris.antognini.ch · 29/04/2026

I fully agree with you. The same is true for calls with a small group of people. Just keep the camera on.

110

Chris Antognini @chris.antognini.ch · 28/04/2026

Also the Acquadome in Billund was good time...

010

Reposted by Chris Antognini

The Economist @economist.com · 25/04/2026

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

econ.st

The high price of forever wars

Binyamin Netanyahu is quick to start conflicts, but shows no ability to end them

3175

Reposted by Chris Antognini

Tanel Poder @tanelpoder.com · 15/04/2026

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

054

Chris Antognini @chris.antognini.ch · 16/04/2026

As I can't see any advantage to using this feature over SQL trace and active session history, especially given the limited number of monitored SQL statements. To make it useful, a much better implementation is needed.

010

Reposted by Chris Antognini

knitting bee🐝 masked & vaxxed @knittingbee.bsky.social · 11/04/2026

We couldn't have done it without her.💐

91589388

Chris Antognini @chris.antognini.ch · 01/04/2026

There are several harvests per year. So, it depends ;-)

030

Chris Antognini @chris.antognini.ch · 01/04/2026

I fully agree, it's a very good one. Since it’s set in the region where I live, it comes up in conversation quite regularly.

110

Reposted by Chris Antognini

Toon Koppelaars @toonkoppelaars.bsky.social · 29/03/2026

youtube.com/watch?v=mD1g... My favorites: #10 and #1. But all are spot on.

youtube.com

10 Relational Database Mistakes, Ranked

YouTube video by Decomplexify

132

Chris Antognini @chris.antognini.ch · 15/03/2026

IMO it's even worse. Both things are true at the same time (lying and no clue). You can't believe anything he's saying. Ever.

020

Reposted by Chris Antognini

Tanel Poder @tanelpoder.com · 13/03/2026

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

4215

Chris Antognini @chris.antognini.ch · 11/03/2026

Being prepared to improvise is essential during a presentation...

100

Chris Antognini @chris.antognini.ch · 23/02/2026

First of all, there are not many important contacts to notify (at least for most people you are referring to who are unable to own their own domain). You can notify them. Second, you don't disable your old address when you start using the new one. This gives you months to react to things you forgot.

100

Chris Antognini @chris.antognini.ch · 23/02/2026

You should not feel held hostage. In fact, you can move your emails somewhere else, and you can change your email address. No big deal. It's like moving to another place. We are used doing it and we don't care that much. NB: in any case, I'm happy to use my own domain since 1999.

100

Chris Antognini @chris.antognini.ch · 20/02/2026

Also note that when the feature is enabled PDB-wide, I can disable and re-enable it using the ALTER SESSION statement. It seems that the implementation is rather peculiar... Also, the way buffers disappear and reappear when you disable and re-enable it is quite strange.

000

Chris Antognini @chris.antognini.ch · 20/02/2026

Yes, things seem to work as expected when I enable it at the system level.

000

Chris Antognini @chris.antognini.ch · 20/02/2026

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

200

Chris Antognini @chris.antognini.ch · 19/02/2026

Yeap, since 12.2 using v$diag_trace_file_contents is the way to go. The only issue I'm aware with it is that lines that don't fit in the VARCHAR2(4000) are silently cut.

010

Chris Antognini @chris.antognini.ch · 15/02/2026

English is the only one that matters to me (and, I guess, to Apress too). Additional languages depend on other publishers that are interested in buying the rights and pay for the translation.

000

Chris Antognini @chris.antognini.ch · 14/02/2026

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

7335

Chris Antognini @chris.antognini.ch · 02/02/2026

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

020

Chris Antognini @chris.antognini.ch · 02/02/2026

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.

010

Chris Antognini @chris.antognini.ch · 31/01/2026

It was a great pleasure to have you at those events. Since I'm still 9.5 years away from reaching the official retirement age, plenty of things could happen. Anyway, I'll try my best to enjoy life ;-)

000

Chris Antognini @chris.antognini.ch · 31/01/2026

I love(d) my job too. But, on the one hand, there are plenty of other things I want to do; on the other hand, I was more and more tired of the (uninteresting) business obligations. In any case, IT will be part of my future too... but only for fun or personal interests.

020

Chris Antognini @chris.antognini.ch · 31/01/2026

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.

4150

Reposted by Chris Antognini

Markus Winand @winand.at · 28/01/2026

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 :) 🧵

Infographic showing that PostgreSQL supports FILTER since 2015, followed by H2 and SQLite in 2019, DuckDB 2024 (first tested release) and now Oracle in 2026.

181