Oracle Tuning - Stabilize Performance when Upgrading Database with SQL Baselines (1 of 6)

Part 1 of 6. See all videos /playlist/PLqg1piEvDWZhYL3TL6GzS-0dgMbjO6TmW . Stop performance regression when upgrading Oracle Database! Use sql plan baselines to maintain consistent performance when upgrading an Oracle Database. This video is the introduction, including the agenda, to all 6-lessons in the tutorial. Watch all lessons - FREE - at: https://skillbuilders.com/course/how-to-fix-oracle-performance-upgrading-sql-baselines/ 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 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. Recommended Prerequisite: How to Read an Execution Plan - /watch/kKWPF_RbVcbbP Presenters: John Watson, Oracle Certified Master DBA, https://skillbuilders.com/ Audience: Oracle DBAs

الفئة Science & Technology