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) Python
• 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 Pricing:

• $649 USD for Free members
• $519 USD for Essential and Advantage members (ask for your coupon code)
• FREE for Prime members (just ask to be registered)

Class Outline:

Session 1. Truthful time, work and their relationship

Session 2. AWR data analysis and charting using Python

Session 3. System thumbprints, utilization and response time

Session 4. How and why a solution impacts performance

Session 5. Maximizing performance while balancing expectations

Details: 

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 Python. Python can be quickly downloaded and installed on Windows and OS X. Craig demonstrates this during the second session. Microsoft Excel is not used.