HammerDB — 2 Technical Articles

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.

AutoUpgradeDatabase UpgradeHammerDB

0 likes · 11 min read

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

ITPUB

Dec 18, 2019 · Databases

Step‑by‑Step Guide to Upgrading Oracle Database 19c with Hands‑On Labs

This tutorial walks you through preparing a virtual‑machine environment, generating workload and AWR snapshots with HammerDB, capturing and exporting SQL tuning sets, performing a manual upgrade from Oracle 11.2 to 19c, and comparing performance before and after the upgrade, all with detailed commands and screenshots.

19cAWRDatabase Upgrade

0 likes · 12 min read

Step‑by‑Step Guide to Upgrading Oracle Database 19c with Hands‑On Labs