Defining a Problem

Defining Problems

Problems can arise at any time. A proactive DBA watches for problems and corrects them before they are noticed by users. In the past, the discovery and definition step has been tedious and frequently dependent on listening to user feedback. User feedback is important, but is often subjective and not reproducible. In Oracle Database 11g, many of the information sources can be viewed from the Enterprise Manager interface.

• Monitor the current state of the database instance and compare it to a previous state.
• Examine AWR or Statspack reports and instance files carefully.

Objectives

• Identify performance issues
• Set tuning priorities
• Interpret tuning diagnostics
• Tune for life cycle phase
  
  

Topics

1. Limit the Scope
2. Defining the Problem
3. Setting the Priority
4. Top SQL Reports
   
5. Common Tuning Problems
6. Tuning During the Life Cycle
7. ADDM Tuning Session
8. Performance Versus Business Requirements

Refer the links below:

Performance Tuning Overview
Performance Tuning Exam(1Z0-054)