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

SYSTEM tablespace is full with audit records? Move it to another tablespace!
Procedure to migrate Oracle audit logs to a tablespace other than SYSTEM, using the DBMS_AUDIT_MGMT package.
Read More
Rebuilt OraInventory
Deleted the OraInventory? Not all is lost
Learn how to recreate a corrupted or deleted Oracle oraInventory, using runInstaller to attach the Oracle Homes.
Read More
My table is gone, confess: who did it?
You notice that a table has disappeared. You can use Logminer to find out who dropped it.
Read More
Missing archivelog? Do not rebuild your standby database
The synchronization of the physical standby in Oracle has halted, and you don't have the required archivedlogs? It is still possible to synchronize without having to rebuild it; learn how.
Read More
Troubleshoot: data guard synchronization stuck with error ORA-01274
How to deal with ORA 01274 error in Oracle, after adding a datafile in primary site, causing standby to stop synchronizing
Read More

Need Help?

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