Stefan Oehrli

Using the SQL analysis report to find queries in the cursor cache which can’t use indexes

The #SQL analysis report in Oracle AI Database 26ai shows potential problems in a query

Cartesian products
UNION
Non sargable filters (can’t use indexes)

You can use this to find queries in the cursor cache which you may be able to improve

Select AI example use cases

Example using select AI to find the top 10 streamed movies after 2010

Run natural language queries against Oracle AI Database with

SELECT AI <your query>

e.g.

SELECT AI what are the top 10 movies

Michelle Malcher demos and gives example use cases for it #AIWorld

Nothing quite like an #OracleACE gathering. #OracleAIWorld

Great session on autoupgrade hacks @mikedietrichde.com @martinberger.bsky.social @alexzaballa.bsky.social @oracleace.bsky.social #AIWorld

The award for the most beautiful graphics at @Oracle AI World on the slides goes tooooo: @stefanoehrli.bsky.social #madewithpassion @excalidraw.com @oracleace.bsky.social

Yet an other Hands-on Lab on @Oracle Data Safe @oracleace.bsky.social #accenture #AIWorld #AIWorld25

#DOAG2025: Im "Security Panel: Datenbanksicherheit mit KI-Unterstützung?" könnt ihr mit den Securityexperten Cornelia Heyde und Dr. Matthias Mann diskutieren. ➡️ scomp.ly/aeRedza

🔗Anmeldung | scomp.ly/YAj48bE

#Security #KI #Datenbank

Oracle AI Database 26ai replaces Oracle Database 23ai Larry Ellison announced Oracle AI Database 26ai  today in his keynote at Oracle AI World conference in Las Vegas. And I am pretty certain you may want some clarification on what this means exactly.…

Great blog post why and how 23ai is now 26ai - the release numbers explained by @mikedietrichde.com : mikedietrichde.com/2025/10/14/o... @oracleace

Why should you join the #OracleACE program and what does it enable you to do?

Hear from @stefanoehrli.bsky.social

#OracleAIWorld

Hands-in Lab at #AIWorld on Data Safe @oracleace.bsky.social #accenture

2nd day of #AIWorld, yet another run. This time to the other end of the Strip.

Kicked off my #AIWorld week with a quick morning run to the fabulous Las Vegas sign. @oracleace.bsky.social

Datenbankpannen made in Switzerland: Von DropTable bis Split-Brain – Teil 2 unserer DOAGtv-Geschichten mit Martin Klier, @stefanoehrli.bsky.social und @danischnider.bsky.social zeigt, wie Recovery-Nächte auch mal mit Pizza enden ➡️ scomp.ly/Y3DVQmY

YouTube video by doagtv Zwischen Linux-Fallen und Virenscanner-Schocks: Datenbankgeschichten aus der Schweiz

Von #SQL-Horror bis Dialekt-Wirrwarr: Die erfahrenen Oracle-Experten und ACEs @stefanoehrli.bsky.social, @danischnider.bsky.social und Martin Klier sprechen im DOAGtv 🎥 über #Datenbank Pannen, #Performance Fallen und wie Humor beim #Recovery hilft.

Teil 1/2 ➡️ youtu.be/a8uolY6Or1U

What is a schema in Oracle and what does the CREATE SCHEMA command do? - www.petefinnigan.com/weblog/archi... - #oracleace #sym_42 #oracle #database #security #create #schema

Thank you for joining us yesterday for the August ACE Program Update meeting! It was great seeing 80+ of our members and learning from our ACEs @loiane.bsky.social and @rammpeter.bsky.social. ♠️
Looking forward to seeing you again soon! 🤩
#OracleACE

@excalidraw.com ❤️ - and I know the guy behind the library 😉 cc / @stefanoehrli.bsky.social

At home after a varied conference week ( #doagdb25 #ougn2025 ) and already back at a train station. 😜😎 This time für the SOLA relay. Running with my work colleagues 114.77km around Zurich. @konradhaefeli.bsky.social I‘m waiting for the hamdover on the Uetliberg

Mir wär’s auch noch recht, wenn ein geplanter Nachtzug nicht einfach so spontan wegen einer Baustelle ausfällt, obwohl die da schon länger ist… 😊 meine Reise von Rust nach Kiel war etwas abenteuerlich… 🤪 5mal umsteigen anstelle von 2mal und das mit dem 😴 war nicht ideal 🙃

#ougn2025 I‘m here. The next challenge is not to get lost on the boat... @oracleace.bsky.social

Finally arrived in Kiel😊🥳 looking forward to join #ougn2025 After my exhaustive road trip from #doagdb25 The last summer vacation at the North Sea with the family was quite relaxed with the night train. Doesn't seem to work every time @oracleace.bsky.social

@konradhaefeli.bsky.social da müssten wir uns wohl nächstesmal anschliessen 😊

Moin Hamburg… Road Trip from #DOAGDB25 to #ougn2025
@oracleace.bsky.social @doagev.bsky.social

Getting closer to #OUGN2025 and arriving in Hannover. Time to Rest and enjoy a 🥨☕️ But there are a lot of crazy people out and about at this time... @oracleace.bsky.social #DOAGDB25

Arriving in Frankfurt. Get surprised by the fact that my ICE does change It’s number. I can stay in the train until Hannover 🥳🎉
#DOAGDB25 #OUGN2025 @oracleace.bsky.social

Next stopp on my way from #DOAGDB25 to #OUGN2025 Offenburg finally enter a larger ICE
@oracleace.bsky.social

Let's collect impressions of train stations in Germany. First stage from #DOAGDB25 to #OUGN2025 Rust - Herboltsheim @rgrzegorczyk.bsky.social

Doesn‘t work that well with the night train from #DOAGDB25 Rust to #OUGN2025 Hamburg/Kiel
@oracleace.bsky.social

Advertising for the Oracle ACE Program by ACE Director @stefanoehrli.bsky.social #community @oracleace.bsky.social

Still at #DOAGDB25 but already announced at #OUGN25 😊😎
@doagev.bsky.social @oracleace.bsky.social