Oracle Certified Master DBA John Watson will demonstrate identifying a problem caused by an upgrade from Oracle 11g to 19c, capturing a sql plan baseline on 11g, transferring the baseline to 19c, and showing that the 11g plan is carried through and performance returns to normal.
You’ll learn how to use sql plan baselining to maintain consistent performance when upgrading an Oracle Database!
Background – We all know what happens with performance when you upgrade: 90% of your SQLs run the same, 9% run better, and for 1% performance drops through the floor. And if you are unlucky, it is the 1% that matter. The solution is SQL Plan Baselining. Baselines stabilize your execution plans through the change, letting you upgrade safely. The basic functionality is now available for SE2 as well as EE.
Recommended Prerequisite: Free Tutorial: How to Read an Execution Plan
Presenters: John Watson, Oracle Certified Master DBA, Dave Anderson, SkillBuilders Founder and Oracle Technologist
Audience: Oracle DBAs and Anyone Interested in Oracle Database Upgrades and Performance
Presentation Files (ZIP) – https://skillbuilders.com/wp-content/uploads/2023/02/skillbuilders-demo.txt.zip
- Lectures 1
- Quizzes 0
- Duration 60 minutes
- Skill level All levels
- Language English
- Students 31
- Assessments Yes