Learn to patch the way God intended (S2E3)

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

Learn to patch the way God intended (S2E2)

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

Learn to patch the way God intended (S2E1)

Learn how to patch Oracle RAC database in out-of-place mode and use Gold Image for maximum simplicity and minimum effort.

Troubleshoot: data masking without changing the applications

Learn how to implement the masking of column contents dynamically and without having to modify your applications.

Troubleshoot: PRCA-1051 when trying to register a migrated ACFS filesystem

Learn how to register an ACFS filesystem after migrating the Disk Group containing it to a new Oracle Cluster.

Incremental statistics, are you doing it right?

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!

Troubleshoot: a non-regular solution for “ORA-01502 index is in unusable state”

How an error caused by running analyze on a table with unusable indexes is solved with regular expressions and dbms_stats.

How to add and drop disks efficiently in ASM?

Are you about to add, drop or replace disks in ASM? You may not be doing it in the most efficient way. Learn how.

Schrödinger’s Fast Recovery Area

What to do when Oracle reports an incorrect value for the space used in Fast Recovery Area.

DataGuard switchover with wallet: ORA-01017

Learn how to resolve and avoid the ORA-01017 error when you have Oracle Data Guard with wallet implemented.