Blog Archive
These are my picks for the top five Oracle-related articles from July 2025.
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.
Learn how to patch Oracle RAC database in out-of-place mode and use Gold Image for maximum simplicity and minimum effort.
Learn how to implement the masking of column contents dynamically and without having to modify your applications.
Learn how to register an ACFS filesystem after migrating the Disk Group containing it to a new Oracle Cluster.
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!
How an error caused by running analyze on a table with unusable indexes is solved with regular expressions and dbms_stats.