Migrate to Oracle 26ai without surprises (Data Guard)

Multitenant is mandatory in Oracle 26ai. Learn how to upgrade from 19c non-CDB to 26ai, including full migration to CDB with Data Guard.

Migrate to Oracle 26ai without surprises

Multitenant is mandatory in Oracle 26ai. Learn how to upgrade from Oracle 19c Non-CDB to 26ai, including the full migration to Container Database (CDB).

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.

AutoUpgrade, my first incident

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