Build Your Own Air Quality Monitoring System Introduction When you have multiple Awair air quality sensors scattered around your home or office, checking each one individually through their apps gets tedious. I wanted a centralized dashboard …

Another fine Oracle 23ai[c] database and Python project done with Claude. This stuff is getting interesting.
cynicalgsd.com/2026/01/24/b...
Next projects:
- English Premier League football stats tracker
- IMDB watchlist, streaming service "what's on" calendar
#Oracle23ai #Python #Claude

How to Install and Secure Oracle GoldenGate 23ai Using Silent Mode (Step-by-Step Guide) Oracle GoldenGate (OGG) continues to evolve as the gold standard for real-time data replication and streaming. With its refreshed architecture, modern security, and automation features, it’s now ea…

𝗔 𝘀𝗶𝗹𝗲𝗻𝘁 𝗶𝗻𝘀𝘁𝗮𝗹𝗹 𝗱𝗼𝗲𝘀𝗻’𝘁 𝗺𝗲𝗮𝗻 𝗮𝗻 𝗶𝗻𝘀𝗲𝗰𝘂𝗿𝗲 𝗼𝗻𝗲.

𝗜𝗻𝘀𝘁𝗮𝗹𝗹𝗶𝗻𝗴 𝗢𝗿𝗮𝗰𝗹𝗲 𝗚𝗼𝗹𝗱𝗲𝗻𝗚𝗮𝘁𝗲 𝟮𝟯𝗮𝗶 𝘀𝗶𝗹𝗲𝗻𝘁𝗹𝘆 𝗮𝗻𝗱 𝘀𝗲𝗰𝘂𝗿𝗲𝗹𝘆, 𝗻𝗼 𝗰𝗹𝗶𝗰𝗸𝘀, 𝗳𝘂𝗹𝗹 𝗮𝘂𝘁𝗼𝗺𝗮𝘁𝗶𝗼𝗻, 𝗮𝗻𝗱 𝗧𝗟𝗦 𝗲𝗻𝗰𝗿𝘆𝗽𝘁𝗶𝗼𝗻 𝗶𝗻𝗰𝗹𝘂𝗱𝗲𝗱.

👉 database-verse.com/2025/10/28/h...

#OracleGoldenGate #Oracle23ai #Automation #Databases #OracleACE

DevTalk Insight 🎥
Beim letzten DevTalk hat @matthiasschulz.bsky.social einige Neuerungen von Oracle 23ai gezeigt – u.a. das praktische GROUP BY Alias!

Nächster Talk am 16.10. zum Thema: Oracle DB & AI

Kommt live dazu und tauscht euch mit der Community aus! 😊

#DOAGDevs #DevTalk #Oracle23ai #SQL

Oracle23ai, and a new kind of history. TL;DR: I discovered the view to find sql_history of a session. I can use that to report "what a session has done". Much more Simple than vi...

In all the #Oracle23ai New-Feature-stories, how did this one got lost ??

The information in the new V$SQL_HISTORY is a Hidden Gem!

Can we give this thing a bit more attention?
Great Potential as a "Problem Fixer" for Devs, Ops, and DBA's...

simpleoracledba.blogspot.com/2025/09/orac...

Thin Cloning with Oracle Exascale: What You Need to Know Last week I wrote about Exascale. If you missed it, you can check it out here: Exploring Oracle Exascale: Architecture, Storage Changes, and Why It Matters Exascale is impressive in many ways, but …

Oracle Exascale takes cloning to the next level.
𝗦𝗽𝗮𝗿𝘀𝗲 clones? Read only.
𝗔𝗖𝗙𝗦 clones? Performance pain.
Now you get 𝗶𝗻𝘀𝘁𝗮𝗻𝘁, 𝘁𝗵𝗶𝗻, 𝗽𝗿𝗼𝗱𝘂𝗰𝘁𝗶𝗼𝗻-𝗿𝗲𝗮𝗱𝘆 clones.

Check it out latest post about thin clonning with Oracle Exascale

Cheers,
FS

#Oracle #Exascale #Oracle23ai #PDBCloning #OracleACE

🚀 Ready to unlock #MachineLearning in minutes? Join Oracle ACE Director Abi Giles-Haigh as she demonstrates how to launch #Oracle23ai ML with Python—right inside a secure Docker container!
🗓️ Aug 21, 2025 | 9am PT/12pm ET

us02web.zoom.us/webinar/regi...
#AnD_TechCasts

Oracle23ai and python - Pingtime and RoundTrips TL;DR: from my obsession with finding and measuring RoundTrips, I got to tweak with pings and RTs. Some findings, some code. And maybe more ...

Network, Latency.
The eternal problem for distributed applications...

At least 3 sessions at #poug2025 are about "latency"

And I keep digging into RoundTrips and RTTs:
simpleoracledba.blogspot.com/2025/08/orac...

/cc @oracleace.bsky.social
@pougorg.bsky.social
#oracle23ai
#python

Group-by-all is awesome for digging in performance data Oracle Database 23ai Release Update 9 introduces yet another new feature aimed at improving the developer experience with the database: group by all. Just like the new select without from dual clau…

🚨 Oracle DB 23ai Release Update 9 is here! 🚨

🆕 23.9 introduces GROUP BY ALL-no more errors for missing columns in GROUP BY!

Super awesome for ASH queries 😀

📖 Details: martincarstenbach.com/2025/08/06/g...

👉 Try it now in Autonomous DB or any other 23.9 db

#Oracle23ai #OracleDB #SQL

Running Hugging Face models inside Oracle 23ai with ONNX and OML4Py About a year ago, I published a blog post on vector search in Oracle 23ai. At that time, I wasn’t aware of the ONNX format or how it could be used to bring machine learning models into the database. That realization came later, and ever since, I’ve been thinking: "I need to write a follow-up post to cover this!" Well... the time has finally come.

A year ago, I explored vector search in Oracle 23ai using external models. Now, it's all happening inside the database.

ONNX + OML4Py + Oracle 23ai = pure magic (with SQL).

New blog is out! let me know what you think!

Cheers,
FS

#Oracle23ai #AI #VectorSearch #EmbeddingModels #OracleACE

No more manual KILL: Oracle 23ai handles blocking with Priority Transactions If you are a DBA you’ve probably received an urgent call time to time from someone saying my applications is blocked, the query is not ending or you are seeing in the monitoring that blocking session counts is increasing overtime and you are looking for what is going on in the database Good news in 23ai! this is probably going to change (hopefully!)

Kill that session! how many times have we, DBAs, had to do that manually?

Discover how Oracle 23ai’s Priority Transactions feature can resolve blocking automatically by rolling back low-priority sessions, no more manual KILLs

Drop a comment if you've tried this feature
#Oracle23ai #OracleACE

DGPDB Switchover Failed! Lessons from a Live Demo Disaster (and Recovery) It’s been a while since my last blog post life and work kept me busy. But recently, I gave a webinar on Oracle 23ai Per-PDB Data Guard (DGPDB), and let’s just say... the live demo didn’t go as planned 😅 My goal was to showcase a simple PDB switchover in real-time. I had validated everything. All signs pointed to…

My DGPDB switchover demo failed - live.
And honestly? I’m glad it did.

What looked like a simple switchover turned into:
* ORA-28098 (password grace period)
* Dropped PDB by mistake with REMOVE PLUGGABLE DATABASE

It was painful, but I learned a lot, check it out!

Cheers,
FS
#Oracle23ai #DGPDB

Creating Uber-Fast Maps With 23ai Vector Tiles and H3 Indexes: Part 1 Oracle Database 23ai added 300+ new features like the new VECTOR datatype that get most of the attention, but often overlooked are two new features that

Hey, fellow #Oracle23ai enthusiasts! Check out my first-ever article on @redgate-software.bsky.social's SimpleTalk technology portal. I'll show you how to use new #23ai #spatial features like Vector Tiling to make some awesome maps that run at warp speed: bit.ly/23aiSpatialE...

1 hour to go!
See how Oracle Database 23ai + APEX + JavaScript = big dev possibilities.

Join @moreaux-louis.bsky.social to explore server-side JavaScript, NPM integration, and real-world use cases.

#Kscope25 #orclapex #Oracle23ai #JavaScript

ORA-04021 timeout occurred while waiting to lock object during stats gather I recently came across an interesting change in behaviour when gathering stats. Patch 32781163 (Deadlock on library cache lock on MV refresh and dbms_stats gathering the same object) was applied to…

Have a new Oracle blog post about an unexpected problem and a change to the defaults after applying a patch (which is standard functionality in later releases)

#oracle #oracle19C #oracle23ai

chandlerdba.com/2025/06/11/o...

The conference season starts for me next week: I will be at #DOAGDB25 and search use cases for Data Use Case Domain in #Oracle23ai

The full agenda of #DOAGDB25 / #apexconn25 you can find here: meine.doag.org/events/apex-...

@doagev.bsky.social @oracleace.bsky.social @sym42.bsky.social

MERGE and DML RETURNING clause in Oracle 23ai Oracle 23ai finally supports MERGE … RETURNING! A long-awaited feature, but still hard to find in the docs.

MERGE ... RETURNING is now supported in Oracle 23ai.
In my view, it deserves more visibility in the documentation — it wasn’t easy to find. Even LLMs still claim it doesn’t exist (some go as far as inventing error codes). Read more:
#Oracle23ai #SQL #MERGE #OracleDB
blog.sqlora.com/en/merge-and...

ORA-30926 in Oracle 23ai: What’s Changed? Explore how Oracle 23ai improves MERGE behavior and error handling, replacing vague ORA-30926 message with clearer, smarter diagnostics.

Ten years after my first post on the quirks of MERGE and ORA-30926, I took a fresh look at how Oracle 23ai handles it. Clearer error messages, improved diagnostics, and fewer unnecessary restarts. Read the new blog post
#Oracle23ai #SQL #MERGE @oracleace.bsky.social

blog.sqlora.com/en/ora-30926...

Oracle 23ai DB Creation in an ExaCC Fails with DBAAS-60022 Ran into a DB creation failure (DBAAS-60022) while provisioning an Oracle 23ai DB on ExaCC (Image 25.1.3). After digging through logs and a bit of head-scratching, the root cause turned out to be a Java version mismatch — DBCA was compiled with Java 11, but the system defaulted to Java 8. If you're hitting the same issue, I wrote up the root cause, the Oracle bug reference, and a quick workaround that worked for me.

Ran into a DB creation failure (DBAAS-60022) while provisioning an Oracle 23ai DB on ExaCC. After digging through logs, the root cause turned out to be a Java version mismatch. If you're hitting the same issue, I wrote up the root cause, and a quick workaround that work for me.
#Oracle23ai #ExaCC

Lock-free Reservations – Oracle Database 23ai New Feature Quando estamos alterando algum registro em uma tabela no banco de dados o Oracle irá colocar um lock nesse registro para que ninguém mais possa alterar ele até você executar um commit ou rollback. …

Lock-free Reservations - Oracle Database 23ai New Feature

oraclepress.wordpress.com/2025/04/02/l...

@oracleace.bsky.social #oracle #database #23ai #oracle23ai

Just release uc-local-apex-dev v25.2. #orclAPEX 24.2 and 23ai containerized with powerful scripts.

- Upgraded DB to 23.7
- Script to disable archive logging
- Script to test app installs (incl. supporting objects), will output any errors

#orcacle #oracle23ai

Oracle AI Vector Search Professional Badge

Ich bin seit heute Oracle AI Vector Search Professional!
Spannend was #Oracle23ai alles machen kann. Habe in dem Zusammenhang auch viel über diverse LLMs gelernt.

Mastering Metadata with Oracle’s DBMS_DEVELOPER in 23.7 Oracle has introduced numerous features in 23ai, with a significant focus on developers—don’t you agree? I certainly think so! Let’s take a look at some of the things Oracle has done to enhance the developer experience in this release: AI Vector Search: This feature enables fast similarity searches on both structured and unstructured data by utilizing vectors. It allows developers to integrate AI capabilities into applications without requiring specialized AI expertise.

🚀 Explore the power of Oracle DBMS_DEVELOPER in 23.7! Unlock metadata with the GET_METADATA function for faster, simpler JSON-based insights. Dive into my latest blog for examples, use cases, and real-world tips.

#Oracle23ai #Database #23.7

Training Days 2025 | Rocky Mountain Oracle Users Group RMOUG Training Days 2025 is a free event to explore AI innovations

Only a few more weeks until #RMOUG25 starts! I'm bringing my A-game - as in #artificialintelligence and Automatic In-Memory for #oracle23ai. Join me and my cohort of knowledgeable presenters near Denver on Feb 12-13 for trainings, networking, and fun! Register here: www.rmoug.org/page/3046363...

Arranca 2025!! 🎉 ¿aun no ha llegado el fin del mundo?
Pues vamos a tomarnos un café en el 🎙️podcast de Café Database 🎙️ para seguir hablando de #Oracle23ai y cositas que se vienen en alta disponibilidad ( #RAC , #DataGuard, etc.) con Carla Muñoz López !
Miércoles 15 enero a las 18h hora Madrid CET

Oracle 23ai, Domains, Enums and Where-Clauses. TL;DR: In Oracle23ai, the DOMAIN type is a nice addition to implement more sophisticated Constraints. Someone suggested the DOMAIN of type ...

My script-addiction got me again:
One more try-this-out-script turned into a blog..
(I’ll stop now, plenty more ideas but too much effot to remove typos).

@oracleace
#SQL
#oracle
#oracle23ai

simpleoracledba.blogspot.com/2024/12/orac...

Café Database en español Podcast · Javier Morales Carreras · Prepárate un café y vamos a charlar sobre bases de datos Oracle, Cloud, Optimización y temas "no-solo-Oracle" en este podcast de divulgación, opinión, crítica y edu...

Ya puedes escuchar el 🎙️último episodio del podcast 🎙️de ☕Café Database☕ con Mónica Godoy y Valentin Leonard Tabacaru sobre APEX y Oracle23ai 🚀🔥grabado en directo!

#cafedatabase #podcast #oracleace #oracle #apex #ai #oracle23ai #vectorsearch #APEXtour #apexvsforms open.spotify.com/show/1GcPTU5...

Oracle 23ai, Domains, Enums, use-cases. TL;DR: The new DOMAIN type in Oracle23ai can be used as LoV. And in some cases that can save you Effort: if it does not have to visit the F...

Could not resist trying out some (simple!) SQL in #Oracle23ai. Using DOMAIN types for LoV. Was Interesting. The resulting test/tweak/demo script is at the end of the blogpost.

#Oracle
#Oracle23ai
@oracleace.bsky.social

simpleoracledba.blogspot.com/2024/12/orac...

On the Seventh Day of 23ai, Viscosity Gave To Me… Discover how generative AI and vector databases are revolutionizing data retrieval, making it more intuitive and efficient for modern applications.

I was honored to write a guest blog post to this fun initiative of series of #Oracle23ai posts.
🎄The 12 Days of Oracle 23ai 🎄

Generative AI and Vector Databases: The Future of Data Retrieval

#vector #GenerativeAI

blog.viscosityna.com/the-twelve-d...

Oracle 23ai - enums, what is behind the scenes ? TL;DR: The DOMAINs in Oracle 23ai are an additional way to add constraints to your Datamodel and you should investigate this to make your ...

Had some Good Fun trying out the DOMAIN ENUM type in Oracle23ai. Looks Promising.

simpleoracledba.blogspot.com/2024/12/orac...

@oracleace.bsky.social
#Oracle
#Oracle23ai

With Special Thx to @chrisrsaxon.bsky.social for sparking The Idea for all this tweaking.

Enabling Autonomous Data Guard in Oracle Autonomous Database 23ai In today's fast-paced digital world, ensuring the availability and reliability of your databases is paramount. Oracle's Autonomous Database 23ai, combined with Autonomous Data Guard, offers a robust s...

Enabling Autonomous Data Guard in Oracle Autonomous Database23ai
#OracleACE #OracleFamily #OCI
#OracleCloud #AutonomousDatabase #AutonomousDataGuard #DisasterRecovery #CloudComputing #BusinessContinuity
#CloudServices #Oracle23ai
#DigitalTransformation

www.linkedin.com/pulse/enabli...