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

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
The OH in one node of a Cluster has wrong owner and group
Oracle Home permissions corrupted? Solve it in a jiffy!
Learn how to fix corrupted permissions on an Oracle Home, either Oracle Grid or Oracle Database Server.
Read More
Secure connection using a wallet
Nothing to hide
Learn how to improve the security of your applications using Oracle Wallet / Secure External Password Store.
Read More
Application shows wrong time
Fighting against the clock
What to do when we find that the database returns the time advanced or delayed for no apparent reason.
Read More
password rollover - rolling app timeout
Password change, zero impact!
Learn how to change the password of an Oracle user, without interrupting the applications service.
Read More

Need Help?

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