- This event has passed.
How to Stabilize Performance when Upgrading an Oracle Database – Free Webinar
June 17, 2020 @ 9:00 am - 10:00 am EDT
Stabilizing Performance when Upgrading an Oracle Database
SQL Plan Baselines Are Your Friend
Recommended Prerequisite: Free Tutorial: How to Read an Execution Plan
Learn how to use sql plan baselining to maintain consistent performance when upgrading an Oracle Database.
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 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.
Oracle Certified Master DBA John Watson will demonstrate identifying a problem caused by an upgrade from 11g to 19c, capturing a baseline on 11g, transferring the baseline to 19c, and showing that the 11g plan is carried through and performance returns to normal.
Oracle Certified Master DBA John Watson
Moderator – Dave Anderson
All webinars are recorded and posted as tutorials. See all tutorials HERE
By registering for the webinar, you will be placed on SkillBuilders mailing list. You will have the option to opt-out of the mailing list at any time.An extra-special event!
June 17th, 2020
All dates are in Eastern Time (ET).