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…

When people hear Exadata in OCI, the first reaction is usually “so it’s all the same thing, right?” Not quite. Oracle actually offers several flavors of Exadata in the cloud. There’s ExaDB-D, the d…

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 …

I’m quite familiar with Exadata platforms, having been lucky enough to work on several projects over the past five years helping customers migrate their on-premises database workloads to the cloud. Most of these have been to Exadata Cloud at Customer (ExaDB-C@C) and Exadata on Dedicated Infrastructure (previously ExaCS, now ExaDB-D). When I first heard about Exascale (Oracle Exadata Database Service on Exascale Infrastructure…

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.

Over the past few months, I’ve been working with Oracle Dynamic Scaling (ODyS) and Oracle Dynamic CPU Count (ODCC) in a customer environment on EXADB-D X9M and X11. These two tools are game changers if you want to allocate only the resources you really need and, more importantly, save some money. ODyS takes care of scaling OCPUs/ECPUs up or down based on actual demand, so your…

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!)

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…

If you need to patch your database, you want to do it easily, right? why complicate it? As a DBA, I have a choice to avoid interrupting the availability of the database instance. So, why bother stopping the database if you can do something online? In this blog, I want to talk about hot online patching. It is not about RAC rolling patches.

Imagine running an online index rebuild on an Oracle 19c database, only to have it unexpectedly fail. No rollback in progress, no active session, just an error leaving your index in limbo. That’s e…

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.

In today's world, data security is paramount as organizations face increasing threats to their sensitive information. Oracle Key Vault (OKV) is a secure and standards-compliant key and secrets management appliance that allows you to store, manage, and share your security objects. Oracle Key Vault centralizes key and secrets management across your organization quickly and efficiently. Security objects that you can manage with…