Stefan Oehrli
@stefanoehrli.bsky.social
Oracle DBA, Oracle ACE, data engineering manager @Trivadis @accenture, consultant, teacher, husband, dad and blacksmith
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... 😎🥂
November 21, 2025 at 8:28 AM
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.
November 21, 2025 at 8:20 AM
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.
Reposted by Stefan Oehrli
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 ( )
)
@toonkoppelaars.bsky.social explains at #DOAG2025
#SQL assertions
These enable you to create cross row, cross table constraints with SQL standard syntax
CREATE ASSERTION … CHECK (
[ NOT ] EXISTS (
)
@toonkoppelaars.bsky.social explains at #DOAG2025
November 19, 2025 at 8:23 AM
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 ( )
)
@toonkoppelaars.bsky.social explains at #DOAG2025
#SQL assertions
These enable you to create cross row, cross table constraints with SQL standard syntax
CREATE ASSERTION … CHECK (
[ NOT ] EXISTS (
)
@toonkoppelaars.bsky.social explains at #DOAG2025
Launch into the second day of the conference #DOAG2025 #DOAGrunning @doagev.bsky.social @oracleace.bsky.social
November 19, 2025 at 7:56 AM
Launch into the second day of the conference #DOAG2025 #DOAGrunning @doagev.bsky.social @oracleace.bsky.social
Reposted by Stefan Oehrli
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
🏎️ 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
November 18, 2025 at 1:21 PM
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
🏎️ 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
Christian about generating test data #DOAG2025 @oracleace.bsky.social
November 18, 2025 at 2:07 PM
Christian about generating test data #DOAG2025 @oracleace.bsky.social
Reposted by Stefan Oehrli
Refreshing my MAA/OCI knowledge with Markus. He talks about diamonds 💎 My wife would also enjoy the lecture. 😜😉 #DOAG2025 @oracleace.bsky.social
November 18, 2025 at 12:15 PM
Refreshing my MAA/OCI knowledge with Markus. He talks about diamonds 💎 My wife would also enjoy the lecture. 😜😉 #DOAG2025 @oracleace.bsky.social
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
November 18, 2025 at 7:19 AM
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
Reposted by Stefan Oehrli
🎤 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/
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/
November 14, 2025 at 9:43 AM
🎤 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/
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/
Reposted by Stefan Oehrli
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!
November 11, 2025 at 5:49 PM
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
November 17, 2025 at 9:52 AM
Let's kick off the DOAG conference week with a DOAG run! #DOAG2025 @doagev.bsky.social @oracleace.bsky.social #DOAGrunning
Reposted by Stefan Oehrli
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/...
📅 Nov 12, 7am PT
👉 Save your spot: asktom.oracle.com/ords/r/tech/...
November 10, 2025 at 1:54 PM
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/...
📅 Nov 12, 7am PT
👉 Save your spot: asktom.oracle.com/ords/r/tech/...
Reposted by Stefan Oehrli
🔒 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/...
👉 Register: asktom.oracle.com/ords/r/tech/...
October 29, 2025 at 1:04 PM
🔒 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/...
👉 Register: asktom.oracle.com/ords/r/tech/...
Reposted by Stefan Oehrli
🌐 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
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
October 29, 2025 at 3:36 PM
🌐 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
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
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
October 23, 2025 at 1:35 PM
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
Reposted by Stefan Oehrli
Mastering @oracle TDE Key Management? No problem for @stefanoehrli.bsky.social at the #Swiss @soug.ch day in Zurich. @oracleace.bsky.social #community #shareyourknowhow
October 23, 2025 at 12:12 PM
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
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
October 23, 2025 at 10:38 AM
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
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
Reposted by Stefan Oehrli
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
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
October 16, 2025 at 5:31 PM
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
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
Reposted by Stefan Oehrli
Run natural language queries against Oracle AI Database with
SELECT AI
e.g.
SELECT AI what are the top 10 movies
Michelle Malcher demos and gives example use cases for it #AIWorld
SELECT AI
e.g.
SELECT AI what are the top 10 movies
Michelle Malcher demos and gives example use cases for it #AIWorld
October 16, 2025 at 4:21 PM
Run natural language queries against Oracle AI Database with
SELECT AI
e.g.
SELECT AI what are the top 10 movies
Michelle Malcher demos and gives example use cases for it #AIWorld
SELECT AI
e.g.
SELECT AI what are the top 10 movies
Michelle Malcher demos and gives example use cases for it #AIWorld
Reposted by Stefan Oehrli
Nothing quite like an #OracleACE gathering. #OracleAIWorld
October 16, 2025 at 1:05 AM
Nothing quite like an #OracleACE gathering. #OracleAIWorld
Great session on autoupgrade hacks @mikedietrichde.com @martinberger.bsky.social @alexzaballa.bsky.social @oracleace.bsky.social #AIWorld
October 15, 2025 at 11:23 PM
Great session on autoupgrade hacks @mikedietrichde.com @martinberger.bsky.social @alexzaballa.bsky.social @oracleace.bsky.social #AIWorld
Reposted by Stefan Oehrli
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
October 15, 2025 at 9:59 PM
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
October 15, 2025 at 5:39 PM
Yet an other Hands-on Lab on @Oracle Data Safe @oracleace.bsky.social #accenture #AIWorld #AIWorld25