Performance Engineering For DBAs and Managers
2: Predictive Analysis

• Applied performance engineering • Manage risk • Predict and improve performance •


5 sessions    Standard Price - $649   Email for possible discount.

This class will empower you to scientifically and confidently answer forward-looking questions using linear regression models. These models are extremely precise, very versatile and easy to understand and use. And, what you learn can be applied to any database system, cloud or on-premise environment and on any operating system.

DBAs and their managers get asked future-focused questions all time. If you have been asked about migration into the cloud, sizing, server consolidation or simply how much more power will be needed next year, then you have been asked predictive analysis type questions.

The problem is most of us are not trained to answer these types of questions. This often results in guessing, asking a colleague, searching Google, or watching endless YouTube videos. This class is a much better solution!

This is one of those rare classes where the content will stay with you and can be applied throughout your entire career.

Dates & Registration

Why should I attend this class?

This LVC is a career changer because very few data professionals really know how to perform this kind of analysis. If you want to become one of the few who knows how to quickly answer forward-looking questions with a quantitative risk assessment mindset, then you need to take this class.

You will be taught how to:

  • Assign risk levels to various sizing/package configuration options
  • Assess which cloud package meets your requirements
  • Forecast CPU, IO, memory, and network requirements
  • Create a linear regression model, measure and maximize its precision
  • Integrate forecasted requirements, risk, and hardware capacity
  • Know when and what to upgrade
  • Forecast the impact of workload changes
  • Analyze various hardware scenarios
  • Calculate the impact of new and changed SQL
  • Know how risky it is to consolidate multiple server and database systems

Class Outline

Session 1. Using the process and how to extract and analyze AWR data

Session 2. How to create forward looking linear regression analysis models

Session 3. How to test and understand model precision

Session 4. How to improve model precision

Session 5. How to validate models and forecast


Class Hours: There are 10 hours of live, interactive webinar training divided into five 2-hour sessions. To maximize learning and to work with your busy schedule, there will be a 1-3 day gap between sessions.

Class Structure: OraPub believes you learn more when you freely and actively engage during the training. This is why each session is full of live demonstrations and lots of Q&A time. Craig types a lot during class. This "session log" is available after each session. If you miss a session, you are free to attend that session when the class is offered again.

Watching Recorded Sessions: Each session is recorded and used to create a unique web page just for your class. The recordings can be streamed using any device, but not downloaded. You can re-watch the videos as many times as you wish. The videos and your unique class web page will be available for three years!

Class Homework: After each live session, homework will be available for you to download. The homework consists of a series of investigative questions which allow you to personally experience the session concepts, increasing your retention. Any slides presented during the sessions will also be available for you to download.

Class Requirements:

You will need:

  • To have completed OraPub's LVC, OraPub Performance Engineering For DBAs and Managers - 1: Core Truths
  • The ability to connect to the online training over the internet, hosted by Zoom. You do not need a microphone. Craig is the only one that speaks but all students are able to type their questions, answers, and comments... it's very lively! Oracle software is not required during the live training.
  • Time to do the homework. You can expect the homework to take between 30 to 60 minutes.
  • The ability to connect and query AWR or Statspack data from an Oracle system. You can connect to Oracle using the tool of your choice, such as SQL*Plus or SQL Developer. We do not use OEM. Also, Craig only uses SQL*Plus, so you can type exactly what he types.
  • The ability to download and install R, a free statistics package. R can be quickly downloaded and installed on Windows and OS X. Craig demonstrates this during the first session. Microsoft Excel is not used.

Bonus: Craig is offering a free review for one of your production system forecasts. You do the analysis, email your findings to Craig, and he will give you his assessment of your findings!

Performance Engineering For DBAs and Managers - Core Truths | OraPub