Abstract: A successful performance tuning methodology using the database health check

1. This discussion will cover a successful performance tuning methodology and uncover the steps needed to detect, diagnose and resolve issues on Oracle databases. A ‘health check’ of a database will yield information needed to take the guesswork out of tuning and the presenter will define and outline what a database health check is as well as how to employ this practice as the core of a successful performance tuning methodology.

2. Tuning Oracle goes well beyond SQL and simple reactive troubleshooting. A successful performance tuning methodology will chart a path to detect, diagnose and resolve database issues for both proactive and reactive tuning. Using a ‘health check’ involves profiling of the respective database, collecting information at a defined interval, analyzing those collections and presenting the findings with information that takes the guesswork out of tuning. This presentation will define and outline the health check procedures as well as how to employ this practice as the core of a successful tuning methodology.

Speaker Bio:

Azeem Mohamed is a Product Marketing Manager for the Oracle solutions at Quest Software Inc. He has over 8 years technical experience working with Oracle, holding positions from DBA, to Senior Systems Engineer and High Availability Architect. As an Oracle Certified Professional, Azeem has both applied database management experience as well as acquired knowledge from working closely with the many industry experts and speaks often at local Oracle user groups and training conferences. Recently published white papers include “A Successful Performance Tuning Methodology” and “Understanding Oracle 9i Advisories”.

GCOUG Home Page