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

The OH in one node of a Cluster has wrong owner and group
Oracle Home permissions corrupted? Solve it in a jiffy!
Learn how to fix corrupted permissions on an Oracle Home, either Oracle Grid or Oracle Database Server.
Read More
Secure connection using a wallet
Nothing to hide
Learn how to improve the security of your applications using Oracle Wallet / Secure External Password Store.
Read More
Application shows wrong time
Fighting against the clock
What to do when we find that the database returns the time advanced or delayed for no apparent reason.
Read More
password rollover - rolling app timeout
Password change, zero impact!
Learn how to change the password of an Oracle user, without interrupting the applications service.
Read More
OOP patching - install golden image
Learn to patch the way God intended (S1E3)
Third post of a series dedicated to the art of Oracle patching. We continue with out-of-place patching, simplified using Gold Image.
Read More
out-of-place patching - patch new OH
Learn to patch the way God intended (S1E2)
Second post of a series dedicated to the art of Oracle patching. We continue with out-of-place patching, the recommended and also the most efficient way.
Read More

Need Help?

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