-
Most Common Oracle Wait Events
Every DBA knows how to read the Top 5 Timed Events section of an AWR report. The common ones — db file sequential read, log file sync, buffer busy waits — are covered in every Oracle performance tuning course. What separates senior DBAs from intermediate ones is recognizing the less common wait events that indicate… Continue reading
-
Oracle Multitenant architecture at 26ai
The Oracle Multitenant architecture promised consolidated databases with workload isolation. The reality, in environments I’ve worked with, is that the isolation part often gets implemented incompletely. Teams spend time on the CDB/PDB structure itself and not enough time on the resource management and monitoring layers that actually enforce isolation. The result: a noisy neighbor problem… Continue reading
-
ORA-01555 vs ORA-01628
In my years of Oracle DBA work, I’ve seen these two errors confused more times than I can count. Both involve undo. Both appear during long-running operations. Both are blamed on “undo tablespace too small.” But they have fundamentally different root causes, different diagnostic paths, and different fixes. If you treat ORA-01628 like ORA-01555, you’ll… Continue reading
-
RMAN in Oracle 19c vs 26ai — What Changed??
Every time Oracle releases a major version, DBAs carefully review new SQL features and optimizer changes — and then quietly forget to review backup and recovery changes until something breaks in production. Oracle AI Database 26ai brings some of the most significant RMAN and security changes since the introduction of the Multitenant architecture. Some of… Continue reading
-
Oracle AI Database 26ai — The Features That Will Change How You Build Applications?
If Blog Post 26 covered what 26ai means for DBAs managing infrastructure, this post is about what it means for the teams building applications on Oracle. The developer experience improvements in 26ai are substantial — JavaScript stored procedures, enhanced vector search with sparse vectors and binary formats, natural language interfaces, AI agent frameworks, and SQL… Continue reading
-
Oracle 23ai to 26ai — What Actually Changed?
n October 2025, Oracle made an announcement that made most DBAs read the headline twice: Oracle Database 23ai was being renamed Oracle AI Database 26ai. A simple rebranding? Absolutely not. This is Oracle’s most significant database release positioning in years, and the technical changes underneath the name are substantial. As someone who has been tracking… Continue reading
-
Oracle Performance Tuning in 2025 — Starting With AWR Before Touching Anything Else?
Every Oracle performance engagement I’ve been part of has followed the same pattern when done correctly: start with AWR, form a hypothesis, validate with deeper tools, then act. The engagements that go badly almost always involve someone who acted before they understood — adding an index, changing a parameter, rewriting a query — based on… Continue reading
-
Oracle Scheduler in 2026— Need to Replacing Cron Jobs?
If you’re still running Oracle-related batch jobs as OS cron jobs or Windows scheduled tasks, you’re missing one of Oracle’s most underused built-in capabilities. Oracle Scheduler (DBMS_SCHEDULER) has been available since Oracle 10g and in 2025 it’s significantly more capable than most DBAs realize. It provides job scheduling, dependency chains, windowed execution, resource integration, logging,… Continue reading
-
OCI Exadata Database Service vs Base Database Service — Making the Right Choice? But how?
When customers start their Oracle Cloud journey, one of the first decisions they face is which compute platform to run their databases on. OCI offers several options, but the choice most production Oracle shops wrestle with is between Base Database Service (DB System) and Exadata Database Service (ExaDB-D, formerly Exadata Cloud Service). The cost difference… Continue reading
-
Oracle 23ai SQL Domains — Writing Less Code While Enforcing More Rules
One of the quieter but genuinely useful features in Oracle 23ai is SQL Domains. It doesn’t have the headline appeal of AI Vector Search, but for development teams building new applications on Oracle, it addresses a real and persistent problem: the same validation logic duplicated across dozens of table columns, the same formatting rules re-implemented… Continue reading
AWARDED TOP 60 ORACLE BLOGS SINCE 2018
Recent Posts
- Most Common Oracle Wait Events
- Oracle Multitenant architecture at 26ai
- ORA-01555 vs ORA-01628
- RMAN in Oracle 19c vs 26ai — What Changed??
- Oracle AI Database 26ai — The Features That Will Change How You Build Applications?
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 