Performance Engineering For DBAs and Managers
1: Core Truths

• Applied performance engineering • Know why solutions really work • Make the complex simple •

  Last year I spent $1000 for Oracle 11g R2 performance training in a reputed institute. I felt like it wasted my money and time. OraPub is worth it to learn advanced tuning techniques. Awesome!”
Nagaraj Goud, Pythian India Pvt Ltd., Oracle Database Consultant

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

All our performance work rests on a few foundational truths. Like axioms, they lay a foundation for more complex analysis. When applied in our work, what seems like an overwelmingly complex and contradictory problem will naturally distill into simple truths and straightfoward solutions.

Exposing and applying these simple yet foundational truths is the focus of this class.

DBAs and their managers are constantly asked complex analysis questions. If you have been asked about why your tuning solution will help, why another will not help, or about migration into the cloud, sizing, server consolidation or simply how much more power will be needed next year, then you have been asked a "core truth" related question.

We should have been taught these core truth axioms when we began our performance analysis and engineering careers. Now is your chance to learn core performance truths that will stay with you your entire career.

Dates & Registration

Why should I attend this class?

This LVC is a career changer because very few data professionals understand the handful of fundamental truths that all our performance analysis/engineering rests upon. By understanding these truths, in a practical way, you inherently know how performance can change or why it won't change. If your work is performance engineering related, you need to take this class.

You will be taught how to:

  • Recognize the differences between cpu time, wait time, elapsed time, db time, wall time, user experience time and response time
  • Relate the various Oracle times to an AWR report's "Load Profile" and SQL statement "Elapsed Times"
  • Extract AWR data, format it for observation and foreign system analysis
  • Install and use (math, analysis, charting) the free statistical package R
  • Strategically use "utilization" and "response time"
  • Quickly isolate why performance changed by creating and using system "thumbprints"
  • Understand why solutions REALLY changed performance
  • Graphically demonstrate why your solutions will change performance
  • Detect a bottleneck even though there is plenty of available power
  • Maximize batch processing throughput while keeping OLTP users happy

Class Outline

Session 1. Truthful time, work and their relationship

Session 2. AWR data analysis and charting using R

Session 3. System thumbprints, utilization and response time

Session 4. How and why a solution impacts performance

Session 5. Maximizing performance while balancing expectations


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:

  • 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 second session. Microsoft Excel is not used.