Skip to Main Content
Hitchhiker's Guide for Upgrading to Oracle Database 23ai

About This Workshop

Youtube Video

About This Workshop
Learn how to upgrade and migrate your database to Oracle Database 23ai. In this workshop, you learn how to use AutoUpgrade to make upgrade and non-CDB to PDB migrations much easier. Further, you can use our Performance Stability Perscription to learn how to avoid the biggest fear of a DBA: bad execution plans after the upgrade. Using tools like SQL Performance Analyzer and SQL Plan Management, you can ensure performance stability after any change - including upgrades and migrations. You will also try migrating a database to a PDB using different techniques. Finally, you learn how to restore after a failed upgrade and downgrade a PDB.

Workshop Info

2 hours
  • Upgrade Oracle Database using AutoUpgrade
  • Convert to multitenant architecture using AutoUpgrade
  • Convert to multitenant architecture using Refreshable Clone PDBs
  • Convert to multitenant architecture using Data Pump
  • Ensure performance stability
  • Capture workload information
  • Detect regressing statements using SQL Performance Analyzer
  • Fix bad plans using SQL Tuning Advisor
  • Avoid plan regressions with SQL Plan Management
  • Restore failed upgrade
  • Downgrade a pluggable database

PLEASE NOTE: This workshop is currently only available on the LiveLabs Sandbox!

 

  • Familiarity with Oracle Database is required
  • Some understanding of database terms is helpful

Other Workshops you might like