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

oop patch grid siha - patch new OH
Learn to patch the way God intended (S2E2)
Learn how to patch Grid Infrastructure for Single Instance, aka Oracle Restart, using out-of-place patching.
Read More
Out of place patching Oracle RAC
Learn to patch the way God intended (S2E1)
Learn how to patch Oracle RAC database in out-of-place mode and use Gold Image for maximum simplicity and minimum effort.
Read More
Hide column contents
Troubleshoot: data masking without changing the applications
Learn how to implement the masking of column contents dynamically and without having to modify your applications.
Read More
Register ACFS file system fails
Troubleshoot: PRCA-1051 when trying to register a migrated ACFS filesystem
Learn how to register an ACFS filesystem after migrating the Disk Group containing it to a new Oracle Cluster.
Read More
Setting incremental statistics for partitioned tables
Incremental statistics, are you doing it right?
If you implemented incremental statistics in releases before Oracle 12.2, you may not be taking full advantage of them. Learn how to do it!
Read More
if there is an unusable index when analyze is executed, expect ORA-1502
Troubleshoot: a non-regular solution for “ORA-01502 index is in unusable state”
How an error caused by running analyze on a table with unusable indexes is solved with regular expressions and dbms_stats.
Read More

Need Help?

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