Seminar Description:

The seminar consists of two full days of an intense, power-packed, lecture-based course with enlightening demonstrations. The key to resolving Oracle database performance issues quickly is to be able to diagnose them effectively 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 two fun-filled, informative days, you will be able to:

• Perform a very methodical 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. Multiple case studies and demonstrations are infused into each seminar. Unique to Craig’s seminars is his knack for making what you learn real. Several times throughout the class, he will place a specific load on a server, diagnose the system, and develop specific solutions.

This seminar goes beyond providing you with the methods, techniques, and tools to maintain optimal performance. You will also learn how to professionally present and articulate your findings in a clear, concise, and effective manner. As an added bonus, a short introductory session on forecasting performance will also be presented.

After co-founding Oracle’s Core Technologies and System Performance Group, Craig opened OraPub, Inc., a company focusing on "doing and helping others do" both proactive and reactive Oracle performance management. He is THE ONLY Oracle industry guru who will make you forget you are learning until you leave excited to return to work and practice what you have learned!

Seminar 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 (wait interface)
• Oracle latching and mutex internals
• Operating system contention identification
• Oracle performance diagnosis 2 (response time analysis and diagnosis challenges)

• Short introduction to forecasting Oracle performance
• Oracle performance diagnosis 3 (active session history)
• Oracle buffer cache management  (internals, diagnosis, solutions)
• Oracle shared pool management (internals, diagnosis, solutions)
• Oracle redo management (internals, diagnosis, solutions)