Top 5: blog posts of September 2025

Recent Posts

if there is an unusable index when analyze is executed, expect ORA-1502
How an error caused by running analyze on a table with unusable indexes is solved with regular expressions and dbms_stats.
We need to add new disks to Disk Group
Are you about to add, drop or replace disks in ASM? You may not be doing it in the most efficient way. Learn how.
Case sensitive comparison
AutoUpgrade fails if the server names are in uppercase, and you are working with an RAC One Node database.
OEM shows incorrect value for used space
What to do when Oracle reports an incorrect value for the space used in Fast Recovery Area.
DG broker using wallet
Learn how to resolve and avoid the ORA-01017 error when you have Oracle Data Guard with wallet implemented.
enq: TX - row lock contention
Learn how to identify the row involved in the occurrence of the wait even "enq: TX - row lock contention"

Need Help?

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