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

We need to add new disks to Disk Group
How to add and drop disks efficiently in ASM?
Are you about to add, drop or replace disks in ASM? You may not be doing it in the most efficient way. Learn how.
Read More
Case sensitive comparison
AutoUpgrade, my first incident
AutoUpgrade fails if the server names are in uppercase, and you are working with an RAC One Node database.
Read More
OEM shows incorrect value for used space
Schrödinger’s Fast Recovery Area
What to do when Oracle reports an incorrect value for the space used in Fast Recovery Area.
Read More
DG broker using wallet
DataGuard switchover with wallet: ORA-01017
Learn how to resolve and avoid the ORA-01017 error when you have Oracle Data Guard with wallet implemented.
Read More
enq: TX - row lock contention
Troubleshoot: enq: TX – row lock contention
Learn how to identify the row involved in the occurrence of the wait even "enq: TX - row lock contention"
Read More
Oracle uses sha512 since RU 19.16
Troubleshoot: CRS-2304 GPnP profile signature verification failed.
Learn how to resolve the CRS-2304 GPnP profile signature verification failed error when starting an 11.2 database on a 19c cluster.
Read More

Need Help?

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