-
OCI Security Best Practices for Oracle DBAs — What You’re Probably Missing
When Oracle DBAs move their databases to OCI, they typically focus on the database itself — configurations, performance, backup. The cloud security layer often gets less attention, usually because it’s managed by a separate infrastructure team. But as a DBA, you’re responsible for your database’s data. That responsibility doesn’t stop at the Oracle listener. Here’s… Continue reading
-
Oracle Multitenant — Common PDB Management Mistakes and How to Avoid Them
Oracle’s Multitenant architecture — Container Database (CDB) with Pluggable Databases (PDBs) — has been around since 12c. It’s no longer new, yet I still encounter the same management mistakes in production environments year after year. Some are minor inefficiencies. Some have caused real outages. This post covers the patterns I see most frequently and what… Continue reading
-
Oracle 19c End of Premier Support in 2024 — Are You Ready for 23ai?
Oracle Database 19c has been the workhorse of enterprise Oracle deployments for the last five years. It’s been the long-term release — the one everyone migrated to from 12c, the one that proved stable enough for even the most conservative production environments. But Premier Support for 19c ended in April 2024. Extended Support runs through… Continue reading
-
OCI Exadata Cloud Service — What the Sales Deck Doesn’t Tell You
Exadata is Oracle’s flagship engineered system — purpose-built hardware and software, Smart Scans offloading query processing to storage cells, Hybrid Columnar Compression reducing storage requirements dramatically, InfiniBand connecting database and storage nodes at extremely low latency. On paper, it’s the most powerful Oracle Database platform available. On OCI, it’s available as a fully managed cloud… Continue reading
-
Oracle Data Guard in 2025 — Beyond the Basics, What Senior DBAs Miss
Data Guard is one of Oracle’s most mature technologies. Most DBAs know how to set it up. The documentation is thorough, the tooling in OCI is excellent, and for straightforward configurations it works reliably. But in eight years of managing Data Guard environments across dozens of customers, I’ve found that the difference between a Data… Continue reading
-
ORA-04031 in Production — It’s Almost Never Just About Memory Size
I’ve been called in on ORA-04031 emergencies more times than I can count. The call always sounds the same: “The database is throwing ORA-04031, we can’t allocate shared memory, users are getting errors, what do we do?” And the first response from most DBAs — including experienced ones — is to increase the shared pool… Continue reading
-
Oracle 23ai Vector Search — Rethinking How We Query Data
For decades, Oracle DBAs have lived in a world of exact matches. You search for what you know. WHERE name = ‘John’. WHERE status = ‘ACTIVE’. The database finds what you ask for precisely, and that’s the contract. But AI-driven applications have fundamentally broken this contract — they don’t search for exact values, they search… Continue reading
-
Oracle RAC Troubleshooting — The Inter-Node Issues That Fool You?
RAC troubleshooting is different from single-instance troubleshooting in ways that are non-obvious until you’ve been through a few incidents. The most frustrating RAC problems are those where everything looks healthy on each individual node, but the cluster as a whole is behaving badly. This post focuses specifically on the inter-node and cluster-layer problems that don’t… Continue reading
-
Oracle CDB vs Non-CDB: A Future-Ready Database Architecture
As you know With the release of Oracle Database 12c, Oracle introduced a major shift in database architecture: the Multitenant Architecture, also known as the CDB (Container Database) model. This marked a revolutionary step in how databases are managed. However, many organizations still rely on the traditional non-CDB structures. In this blog post, we’ll explore… Continue reading
-
Hot Cloning of a PDB in Oracle Database
With the release of Oracle 12c and later enhancements in Oracle 18c and 19c, hot cloning of a Pluggable Database (PDB) has become a powerful feature for DBAs. Hot cloning allows you to clone a PDB while it’s open in read/write mode, without needing to quiesce the source PDB. This is especially useful for: Let’s… Continue reading
AWARDED TOP 60 ORACLE BLOGS SINCE 2018
Recent Posts
- RMAN in Oracle 19c vs 26ai — What Changed??
- Oracle AI Database 26ai — The Features That Will Change How You Build Applications?
- Oracle 23ai to 26ai — What Actually Changed?
- Oracle Performance Tuning in 2025 — Starting With AWR Before Touching Anything Else?
- Oracle Scheduler in 2026— Need to Replacing Cron Jobs?
CATEGORIES
- Cloud Computing Tutorials
- My Presentations
- Oracle Cloud Journey
- Oracle Database&EBS General
- Oracle E-Business Suite Release 11
- Oracle E-Business Suite Release 12
- Scripts for Oracle E-Business Suite
- Some other Oracle Products Installation
- Step by Step Oracle E-Business Suite Installation
- Video Tutorials
HELIOS BLOG 