Stefan Oehrli

They were delicious. I just had another one on my way to the train 🥨☺️

If you want to live a little healthier again after all the various events and food at #DOAG2025 in the run-up to the holidays, remember... 😎🥂

On my last leg back home from the #DOAG2025 conference. Only light snow this year 😉 It was great to meet lots of friends and hear interesting presentations. Thank you @doagev.bsky.social and @oracleace.bsky.social I'm looking forward to next year.

Also mein Zug den ich gebucht habe war heute gar nicht mehr auf dem Fahrplan. Jetzt halt unterwegs Richtung Zürich bis Stuttgart….

SQL assertions syntax

Multi row/multi constraint example “controllers must work in finance”

Multi row/multi table constraints “Can’t earn more than your manager” “Can’t have multiple presidents” “Must be a president”

Coming in Oracle AI Database

#SQL assertions

These enable you to create cross row, cross table constraints with SQL standard syntax

CREATE ASSERTION … CHECK (
[ NOT ] EXISTS ( <query> )
)

@toonkoppelaars.bsky.social explains at #DOAG2025

Started at the same place. 😎

Launch into the second day of the conference #DOAG2025 #DOAGrunning @doagev.bsky.social @oracleace.bsky.social

Yet an other #DOAGrunning

Oracle ACEs from all around the world met yesterday in Nuremberg to enjoy two amazing community events:
🏎️ A racing karting ACE experience 🤩
🍽️ An ACE dinner with 50 guests! 😋
It's so amazing seeing the community come together, have fun, create memories, and network!
#OracleACEs

Data Masking ca also be used without OEM. Just use Data Safe. It is part of the on-prem fee and included in Cloud based DBs anyway @doagev.bsky.social #DOAG2025

Christian about generating test data #DOAG2025 @oracleace.bsky.social

Tirthankar Lahiri introducing vectors and similarity search at #DOAG

Sollte an Konferenztagen ein Auto Hashtag geben 🤭

People who dared to turn up for Kamil’s show

Full house!

Refreshing my MAA/OCI knowledge with Markus. He talks about diamonds 💎 My wife would also enjoy the lecture. 😜😉 #DOAG2025 @oracleace.bsky.social

I forgot to add the famous hashtag #DOAGrunning. 🏃🏻😎

After the hearty menu at the ACE dinner, I balanced things out this morning with a short run, a light breakfast, and now I'm refreshed and ready for the first day of the conference. @oracleace.bsky.social Thank you very much for the dinner. #DOAG2025 @doagev.bsky.social

🎤 Don’t miss DOAG Konferenz + Ausstellung 2025 — Nov 18–21, the premier event for database technologies in the German-speaking region!

Join #OracleACE experts and industry leaders for in-depth sessions on Oracle tech, modern IT trends, open source, and more. 👉 anwenderkonferenz.doag.org/de/home/

Some Oracle ACE Program swag waited for me after returning from two amazing days at the ATP Finals in Turin. Useful stuff for #DOAG2025 next week! Thanks @oracleace.bsky.social!

Let's kick off the DOAG conference week with a DOAG run! #DOAG2025 @doagev.bsky.social @oracleace.bsky.social #DOAGrunning

Are you encrypting your Oracle data right? Get pro tips from @stefanoehrli.bsky.social at our FREE Oracle ACE Live: TDE Demystified—config, keystore management, and more!

📅 Nov 12, 7am PT

👉 Save your spot: asktom.oracle.com/ords/r/tech/...

🔒 Ready to make sense of Oracle Transparent Data Encryption (TDE)? Join #OracleACE Live (FREE) on Nov 12 at 7am PT with Stefan Oehrli for config tips, demos & best practices!
👉 Register: asktom.oracle.com/ords/r/tech/...

🌐 Happy Internet Day! 🌐

Take a moment today to visit your favorite websites (maybe even check out the very first webpage ever created!), connect with friends across the globe, and appreciate how the Internet brings us all closer—one click at a time.
#InternetDay

Yep. Store the basenv packege locally and start an unanttended basenv install in the container

The problem, Oracle stuff can be downloaded and installed using Autoupgrade. Basenv on the other side is not public available 😢 but I provide a script to install it at runtime of the container 😎

First MVP of my new Oracle Database Docker build configuration, which uses Autoupgrade to download the latest RU and create Oracle Home during the build. 😎 @oracleace.bsky.social #oracle #docker #container #autoupgrade

Mastering @oracle TDE Key Management? No problem for @stefanoehrli.bsky.social at the #Swiss @soug.ch day in Zurich. @oracleace.bsky.social #community #shareyourknowhow

Loved Martin’s session at #SOUGDay 🇨🇭
Great, honest take on the Oracle Autonomous Database — what works, what doesn’t, and where it really adds value. @oracleace.bsky.social @doagev.bsky.social @martinberger.bsky.social #SOUG

#OracleDatabase #AutonomousDatabase #OracleCommunity

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