Webinar3_Performance Stability, Tips, Tricks & Underscores_EMEA

views

Oracle Database 19c Upgrade Virtual Classroom - Session 3: Performance Stability, Tips, Tricks & Underscores

Change is the root of all opportunity, at least as far as technology goes. For databases, upgrades and patching bring with them the possibility of unexpected behavioural changes and an improvement in performance. In the worst-case scenario change can mean performance degradation and poor user experience.

To ensure that the worst-case scenario is less likely, Oracle Database includes multiple tools to help administrators baseline SQL performance prior to upgrade, lock SQL execution plans and perform comparative testing to reduce risk during upgrade and patching windows.
In this session, you will learn how to perform proactive testing before upgrading to Oracle 19c. We will share how real application testing can be used to take the guesswork out of change.

Using the SQL Plan Management features such as SQL Plan Baselines & Plan Evolution, we will prevent performance regressing by leveraging known execution plans while ensuring change is introduced in a controlled manner.
Facilitators will share their tips, tricks and underscore parameters to help you get the best out of Oracle Database 19c with an interactive Q&A session.

Topics that will be covered during this session:

Testing Principles
Testing Principles
Ensure Performance Stability
SQL Plan Management
Real Application Testing
Tips, Tricks & Underscores

Tags

Webinar3_Performance Stability, Tips, Tricks & Underscores_EMEA

Related Media