ITPUB

Dec 19, 2019 · Databases

Step-by-Step Oracle 19c Upgrade: Performance Comparison, SPA, and AutoUpgrade

This guide walks through upgrading an Oracle database to 19c, comparing pre‑ and post‑upgrade performance with HammerDB and AWR snapshots, using SQL Performance Analyzer and SQL Plan Management to evaluate SQL tuning sets, applying SQL Tuning Advisor recommendations, and finally automating the upgrade with the AutoUpgrade tool and post‑upgrade compatibility adjustments.