All Things Oracle
Contact Me

Top 5: blog posts from March 2026

March 31, 2026 No Comments
www.vecteezy.com/free-vector/person-looking-at-computer

March is over and, as usual, I’d like to share my list of must‑read articles with you. These pieces either bring us new insights or tackle everyday problems with a simple, engaging approach.

Here it is, without further ado. I hope you enjoy reading it as much as I did!

SQL Assertions
The constraints you’ve been waiting for since 1992! In this practical example, Javier walks us through their strengths and limitations.
I want to read it!
Oracle RAC Startup Architecture
Do you really know the order in which an Oracle RAC actually starts up, or do you just pray that it works? Anish explains it all in a super clear way.
Read It now!
Why oracle’s optimizer has been getting smarter for 15 years and what 26ai version actually adds
From “guess how many rows” to a self-correcting Optimizer: 15 years of magic and what’s new in Oracle 26ai according to Prashant.
Let’s read it!
How to Clone a Non-CDB as a PDB in a CDB with Data Guard Configuration
Data Guard + Non-CDB to PDB: the detail nobody tells you about. Maicon walks you through the full procedure.
Dive into it!
Oracle „Lizenzfalle“ Oracle Standard Edition und Oracle Text Indizes
Watch out: your Oracle Text index on Standard Edition is using forbidden compression without asking for permission! This month’s silent trap, clearly explained by Chris.
Check this out!

Recent Posts

Top5 2025-07
Top 5: blog posts from July 2025
These are my picks for the top five Oracle-related articles from July 2025.
Read More
new: dbms_sqldiag.report_sql
You don’t have to wait for Oracle 23ai to use these new cool features
Starting with Oracle 19.28, the use of IF [NOT] EXISTS and the function DBMS_SQLDIAG.REPORT_SQL is now available. Learn all about them.
Read More
email ACL rules
Troubleshoot: ORA-24247 when trying to send an email
Have you just upgraded or implemented new functionality and encountered the ORA-24247 error? Learn how to resolve it in one simple step.
Read More
MView - Current
Huge materialized view log? Fix it in 5 steps
If you find huge materialized view logs, follow these steps to diagnose the problem and purge their contents.
Read More
slow mview refresh
How to refresh materialized views faster in 19c?
If materialized view fast refreshes are slow and you are using Oracle 19c, you can make a small change to optimize them.
Read More
Grid OOP patching - install golden image
Learn to patch the way God intended (S2E3)
Learn to patch Grid Infrastructure for Single Instance, with out-of-place mode and using a gold image.
Read More

Need Help?

Fill in these details and I will be in touch as soon as possible.