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

Setting incremental statistics for partitioned tables
Incremental statistics, are you doing it right?
If you implemented incremental statistics in releases before Oracle 12.2, you may not be taking full advantage of them. Learn how to do it!
Read More
if there is an unusable index when analyze is executed, expect ORA-1502
Troubleshoot: a non-regular solution for “ORA-01502 index is in unusable state”
How an error caused by running analyze on a table with unusable indexes is solved with regular expressions and dbms_stats.
Read More
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

Need Help?

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