Blog Archive

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.
Out of place patching Oracle RAC
Learn how to patch Oracle RAC database in out-of-place mode and use Gold Image for maximum simplicity and minimum effort.
Hide column contents
Learn how to implement the masking of column contents dynamically and without having to modify your applications.
Register ACFS file system fails
Learn how to register an ACFS filesystem after migrating the Disk Group containing it to a new Oracle Cluster.
Setting incremental statistics for partitioned tables
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!
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.

Need Help?

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