349: Getting Started Optimizing Oracle Performance
Craig Shallahamer , Orapub, Inc.    Biography

Objectives: Learn how to transform a complex performance situation into something understandable and actionable.
Learn how to quickly diagnose problems and develop multiple resolutions.
Learn how to have consistent performance tuning success.
Abstract: Even the documentation states, “The Oracle server is a sophisticated and highly tunable software product.” Then doesn’t it follow that learning how to diagnose and optimize performance should be a complex, daunting, and overwhelming challenge? Absolutely not! Throughout my 12 years of researching, writing, teaching, and consulting I have developed a number of methods and techniques that have allowed literally thousands to learn how to make complex Oracle server tuning simple and straightforward. This paper is aimed at introducing new Oracle DBAs to the world of practical performance diagnosis and resolution. I will start by introducing the concepts and key points, surround them with proven methods, and then demonstrate how to successfully diagnose and set a path towards optimizing performance. Publicly available tools and methods will be used throughout the paper.

Audiernce Focus: DBA
Expertise: Beginner
Track: Database
Date: Wednesday, April 16, 2008
Time: 8:30 AM - 9:30 AM