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

Top5 2025-09
Top 5: blog posts from September 2025
These are my picks for the top five Oracle-related articles from September 2025.
Read More
Top5 2025-08
Top 5: blog posts from August 2025
These are my picks for the top five Oracle-related articles from August 2025.
Read More
Top5 2025-07
Top 5: blog posts from July 2025
These are my picks for the top five Oracle-related articles from July 2025.
Read More
new: dbms_sqldiag.report_sql
You don’t have to wait for Oracle 23ai to use these new cool features
Starting with Oracle 19.28, the use of IF [NOT] EXISTS and the function DBMS_SQLDIAG.REPORT_SQL is now available. Learn all about them.
Read More
email ACL rules
Troubleshoot: ORA-24247 when trying to send an email
Have you just upgraded or implemented new functionality and encountered the ORA-24247 error? Learn how to resolve it in one simple step.
Read More
MView - Current
Huge materialized view log? Fix it in 5 steps
If you find huge materialized view logs, follow these steps to diagnose the problem and purge their contents.
Read More

Need Help?

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