Top 5: blog posts of July 2025
July 31, 2025
No Comments

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

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.

Have you just upgraded or implemented new functionality and encountered the ORA-24247 error? Learn how to resolve it in one simple step.

If you find huge materialized view logs, follow these steps to diagnose the problem and purge their contents.

If materialized view fast refreshes are slow and you are using Oracle 19c, you can make a small change to optimize them.

Learn to patch Grid Infrastructure for Single Instance, with out-of-place mode and using a gold image.

Learn how to patch Grid Infrastructure for Single Instance, aka Oracle Restart, using out-of-place patching.