The key to resolving Oracle database performance issues quickly is to be able to diagnose them systematically and efficiently, combined with a deep practical understanding of the Oracle kernel. Craig Shallahamer’s depth of experience and engaging teaching style will keep you entertained while you learn how to extinguish your company’s database fires expediently.

In just a few fun-filled, hands-on, informative days, you will be able to:

• Perform a repeatable, systematic, and extremely accurate performance diagnosis of even the most complex Oracle systems.
• Understand deep Oracle internal knowledge and how Oracle interacts with both applications and the host operating system.
• Develop multiple sensible and responsible solutions for the same problem.
• Create an honest and understandable story explaining the problem, the solutions, and how to best implement your solutions in a complex and highly available Oracle environment.
• Use the latest Oracle release-specific diagnostic capabilities available in your environment.

Craig emphasizes using a comprehensive approach to maximizing performance from an Oracle, an operating system, and an applications perspective. Unique to Craig’s courses is his knack for making Oracle internals come alive while being day-to-day practical. Reinforcing the performance analysis methods and Oracle internals presented, multiple real-life hands-on case studies are infused into each class and analyzed using OraPub's free response time analysis tools, AWR, and also Statspack!  You will also learn how to professionally present and articulate your findings in a clear, concise, and effective manner.

Students are encouraged to bring an AWR or Statspack report to reference during the class. Plus students are welcome to contact Craig following the course for a one-time free QA of their performance analysis work.

A wonderful companion course is our Advanced Oracle Performance Analysis course, which is typically offered following this course. Discounts are available when you register for both!

Course Schedule: Click here for detailed agenda/schedule.

Day 1 (Fast pinpoint diagnosis every time and in every environment)

• Oracle performance triage (methods and madness)
• Oracle performance diagnosis 1 (quantified, systematic, and spot-on)
• Case Study #1
• Serialization Control; The lock, latch, & mutex (minimizing parallelism death... serialization)
• Operating system contention identification (much more than just identifying the bottleneck)
• Case Study #2

• Oracle performance diagnosis 2 (diagnosis challenges and how to overcome them)
• Case Study #3
• ASH centric response time performance diagnosis
• Oracle buffer cache deep internals, diagnosis, and resolution

Day 3 (Useful & deep internals, quick & accurate diagnosis, with multiple sensible solutions)

• Case Study #4
• Oracle shared pool deep internals, diagnosis, and resolution
• Oracle redo buffer deep internals, diagnosis, and resolution
• Case Study #5

OraPub courses are designed and delivered by Craig Shallahamer, author of: