Go Faster: Make Oracle Work for You! with Craig Shallahamer

Oracle DBAs find it difficult to get complete and correct information about how the database engine works. Even when bits of truth are collected, consolidating the data into a useful performance optimizing solution is complicated. When a diagnosis is incomplete or the DBA doesn't understand why a solution improves performance, solution creation becomes a guessing game resulting in haphazard performance improvement. In this seminar you will learn how selected areas of Oracle work together. The topics are updated constantly to make this seminar fresh for each audience. Care is given as to why performance solutions work and how to make them usable and practical in a complex and highly available production environment.

Why should you attend this seminar?

As an Oracle professional, you know most Oracle performance analysis is based on folklore and non-scientific research. This is obviously not desirable because it leads to an incorrect analysis. This seminar presents a number of very specific performance topics that are analyzed 100% through scientific experimentation and then applied to daily Oracle performance analysis. If you are looking for greater insights than what Google, books or a fancy slide deck can provide, then you'll love this seminar!

Audience
Course Topics Developing a diagnostic framework Statistics for the performance researcher Parsing: hard, soft, and softer... How bad is bad? Cursors, child cursors and more child cursors Altering DML batch sizes for quick commit times Breaking the rules using commit write Who's got the power: core vs thread vs something else Using SQL and wait time skewed data to your advantage Merging time based analysis and queuing theory Systematically solving cache buffer chain problems Are you sure it’s the index root block? Calculating CPU utilization without going to the OS SQL CPU time reliability or not Instrumenting Oracle CPU activity: the missing link
Course Objectives

• Gain deep performance insights
• Learn about Oracle internals that matter when solving performance problems
• Learn how Oracle works based on experimentation, not folklore or Google
• Learn how to maximize Oracle performance in a wide variety of selected areas
• Learn how to quickly understand the merit of a proposed performance solution
• Learn how to setup a quantitative time based diagnostic framework
• Understand why any performance solution will help or not