You will be able to

• Perform a systematic, quantitative and extremely accurate performance diagnosis of even the most complex Oracle systems.
• Understand deep Oracle internal knowledge and how Oracle interacts with applications and the host operating system.
• Develop sensible and responsible solutions for the same problem.
• Create an honest and understandable story explaining the problem.
• Give solutions and implementation constraints in a complex and highly available Oracle environment.
• Use the latest Oracle release-specific diagnostic capabilities available in your environment.
• Know exactly how to move forward, even with stacks of performance data.

All queries, scripts, tools, spreadsheets, and templates referenced are free and downloadable at OraPub's web site.

Why should I attend this course?

In a nutshell, the Firefighting course combines deep Oracle internals with how to methodically and quantitatively diagnose any Oracle system resulting in a list of solutions that you can convincingly articulate. You need these firefighting tools!

Day 1

• Oracle performance triage (building a diagnostic framework)
• Oracle performance diagnosis 1 (systematic and spot-on diagnosis)
• 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 (deeper and more advanced diagnosis)
• Case Study #3
• ASH architecture, control and creative usage
• Oracle buffer cache deep internals, diagnosis and resolution

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

The course contents are continually updated, refined and expanded. We offer 50% discounts if you want to retake the course. It's like a whole new class!

Unique

• Craig’s courses make Oracle internals come alive while being day-to-day practical.
• Craig emphasizes using a quantitative time-based approach to maximizing performance from an Oracle, an operating system and an applications perspective.
• 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.

Details

Discount: Maximize your experience with our Advanced Oracle Performance Analysis course. Take advantage of our 10% discount when you register for both! That's almost a $400 savings!

Equipment: A laptop with an internet browser is required and sometimes provided in the classroom. MS Excel is also nice to have, but not required. Oracle software is not required.

Time: 3 days (9:00am - 5:30pm, 9:00am - 5:00pm, 9:00am - 3:30pm)

Bring: Students are encouraged to bring an AWR or Statspack report to reference during the class.

Bonus: Students are welcome to contact Craig following the course for a one-time free QA of their performance analysis work!