Virtual Classroom Seminar #29 - Statistics and Migrations - Well kept secrets revealed

Today, we are going to share insights into how to handle all sorts of statistics in an Oracle Database when you migrate. Migration could be from one system to another, from one operating system to another, or into any cloud or Oracle Autonomous AI Database and Lakehouse. 00:10 Welcome 03:47 Performance and Migrations 06:05 Different types of statistics in an Oracle database 16:26 Options: Keep stats, regather full or import statistics? 28:30 Performance Stability Prescription - Part 1: Collection and SQL Performance Analyzer 40:50 Fixing bad statements with SQL Plan Management and SQL Tuning Advisor 54:54 Statistics in Oracle Autonomous AI Database 1:03:14 ADB Serverless, Lakehouse - differences and much more 1:13:20 What should ou do?? Real World Advice 1:17:58 The Advanced Solution for Experts and Geeks 1:26:48 Conclusion, summary and Goodbye 📘 Get the slides: https://MikeDietrichDE.com/slides ❓ Read the Q&A: https://MikeDietrichDE.com/slides 🍿 Other webinars: https://MikeDietrichDE.com/videos