Top 5: blog posts of July 2025

Top5 2025-07

Staying informed is crucial, and thankfully, good articles are still coming out. However, to spare you the time and effort of reading them all, I will compile a monthly inventory of the articles that I consider to be indispensable.

It has been difficult to choose from so much excellent content, but I focused on those that offer fresh insights or deal with common issues in an easy-to-understand and entertaining way.

I hope you love reading it as much as I do, so here it is without more delay!

Recent Posts

new: dbms_sqldiag.report_sql
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.
email ACL rules
Have you just upgraded or implemented new functionality and encountered the ORA-24247 error? Learn how to resolve it in one simple step.
MView - Current
If you find huge materialized view logs, follow these steps to diagnose the problem and purge their contents.
slow mview refresh
If materialized view fast refreshes are slow and you are using Oracle 19c, you can make a small change to optimize them.
Grid OOP patching - install golden image
Learn to patch Grid Infrastructure for Single Instance, with out-of-place mode and using a gold image.
oop patch grid siha - patch new OH
Learn how to patch Grid Infrastructure for Single Instance, aka Oracle Restart, using out-of-place patching.

Need Help?

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