Hitchhiker's Guide for Upgrading to Oracle Database 19c

This hands-on lab lets you practice everything you need to successfully upgrade to Oracle Database 19c using AutoUpgrade, the recommended way. In addition, you will learn how to ensure performance stability by using tools like SQL Performance Analyzer and SQL Plan Management. Finally, you will also learn how to migrate to the multitenant architecture and use Full Transportable Export/Import.

After attending this hands-on lab, you can successfully upgrade and migrate to Oracle Database 19c.

Agenda:

  • 10:00 Introduction
  • 10:15 Upgrade to Oracle Database 19c
  • 11:45 Break
  • 12:00 Ensure performance stability
  • 13:00 Lunch
  • 14:00 Hands-On Lab
  • 15:00 Break
  • 15:15 Hands-On Lab
  • 16:00 Q&A
  • 16:30 End

Note: You must bring your own laptop to participate in the lab.

About author

Daniel Overby Hansen

Daniel is a Senior Principal Product Manager for Cloud Migrations at Oracle. He is part of Database Upgrade, Patching & Utilities and thus works with the entire portfolio of the team. Before joining Oracle, Daniel had a long career as operational database administrator and database developer at a global provider of financial services. Daniel’s motto is that databases are fun but when he is not messing with databases, he takes care of his family in Denmark and enjoys the outdoor life with farming, running, and hiking.

 

 

  • DATUM: Sreda, 31. maj 2023
  • LOKACIJA: Kongresni center Portus, Portorož
  • TRAJANJE: 6h

Vsebina:

  • Setup your Upgrade Compute Instance in the Cloud
  • Load the database
  • Capture and Preserve SQL
  • Perform Auto Upgrade tasks
  • Run an AWR Diff Report
  • Analyze SQL
  • Tune and manage SQL Plans
  • Perform upgrades using the plugin method

Predpogoji:

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

CENA*: 95€ + ddv

 

Število udeležencev na delavnici je zaradi interakcije s predavateljem omejeno na 30 ljudi!

*cena za predkonferenčno delavnico velja ob plačilu kotizacije za konferenco MakeIT SIOUG ali JCON OpenBlend Slovenia 2023. V primeru, da bi se delavnice radi udeležili brez udeležbe konference, je cena pred-konferenčne delavnice 210€ + ddv.