You don’t have to wait for Oracle 23ai to use these new cool features

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.

Troubleshoot: ORA-24247 when trying to send an email

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

Huge materialized view log? Fix it in 5 steps

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

How to refresh materialized views faster in 19c?

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

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.

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.

AutoUpgrade, my first incident

AutoUpgrade fails if the server names are in uppercase, and you are working with an RAC One Node database.

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.