Stabilizing Performance when Upgrading an Oracle Database – A Free Tutorial
Duration: 60 minutes

John Watson

No reviews yet.
Free

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.

Presenters:
John Watson, Oracle Certified Master DBA

Dave Anderson, SkillBuilders Founder and DBA

Audience:
Oracle DBAs

  • Call 1-401-783-6172 for Group or Alumni Discounts.
    If you are a student of an accredited academic institution call us for a 25% discount.

    • No Events Scheduled at this time. Call +1-401-783-6172 or email us to schedule this class.

    • 0/6

      • Lecture1.1
        Introduction to Stabilizing Performance when Upgrading an Oracle Database
        Preview
        4m
      • Lecture1.2
        Lesson 1: Why an Upgrade can be Frightening
        13m
      • Lecture1.3
        Lesson 2: Identify and Stabilize an SQL
        17m
      • Lecture1.4
        Lesson 3: Stabilize the Entire Environment
        4m
      • Lecture1.5
        Lesson 4: Let Your Plans Evolve
        15m
      • Lecture1.6
        Questions and Answers to Stabilizing Performance when Upgrading an Oracle Database
        9m
    John Watson
    https://skillbuilders.com/our_team/john-watson/

    Please take this tutorial in order to review.

    No reviews yet.

    Free

    Copyright © Skillbuilders.com