All Things Oracle
Contact Me

Top 5: blog posts from May 2026

June 1, 2026 No Comments
www.magnific.com/free-vector/man-using-laptop-computer_136881009.htm

February ended with many great articles published. To save you time, here is my monthly list of essential reads, focusing on those that offer fresh insights or address common issues in an entertaining, easy-to-understand way.

I hope you enjoy it as much as I do!

Ghost in the Datafile: Fixing “Empty Block” Corruption in Oracle
Have you deleted a corrupt object only to find that your RMAN backups are still failing? Liang reveals how to banish corruption from empty blocks for good.
Check this out!
Password Protection
Did you lose the password for the TDE wallet? David shows how to fix this common problem in a simple and safe way.
Dive into it!
Performance: Index Clustering Factor
Why does the optimizer ignore the indexes and choose a Full Table Scan? Neil reveals the reason behind a confusing Clustering Factor and how to fix it.
Let's read it!
DBMS_STATS.restore_table_stats – Pluft, Plact, Zuummm
Did the new statistics affect performance, and are you thinking about changing them back? José explains how to quickly restore the old stats and return your system to normal.
Read it now!
Unified Auditing in Oracle: Setup, Management, and Purging
Aishwarya leads us through Unified Auditing, sharing hands-on tips on relinking binaries, clever ways to delete records, and mastering partition management.
I want to read it!

Recent Posts

Installing Oracle 11g Release 2 on OEL 5.3
Step by step installation of Oracle 11.2 on Linux, using Oracle Universal Installer in graphical mode.
Read More
How to hide PL/SQL source code? Use Wrap
How to hide stored PL/SQL source code: packages, procedures, and functions in Oracle, using the wrap utility
Read More
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

Need Help?

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