Oracle Database 11g: Performance Tuning Methodology and Tools


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number



Overview/Description
Oracle Database 11g provides a variety of tools that can be used for performance tuning in an Oracle database environment. These tools can be used to diagnose and tune common SQL-related and instance-related problems as well as proactively tune an Oracle database. One such tool – Enterprise Manager – can be used to monitor an Oracle database using the many performance-related pages it provides via a user-friendly graphical user interface. This course provides an introduction to performance tuning methodologies, effective tuning goals, and the types of performance data that can be gathered by diagnostic tools available in Oracle Database 11g. It also demonstrates how to use Time Model and Enterprise Manager to diagnose performance issues, and discusses using the various dynamic performance views (V$ views) to perform statistical analysis when diagnosing problems. The use of alert logs, user trace files, and wait events analysis are also explored in this introduction to performance tuning. This course helps to prepare you for the Oracle Database 11g: Performance Tuning exam which counts towards the Oracle Database 11g Performance Tuning Certified Expert designation.

Target Audience
A range of in-training or established IT professionals; Database Administrators; Support Engineers; Technical Consultants.

Prerequisites
Oracle Database 11g: Administration Workshop I Oracle Database 11g: Administration Workshop II

Expected Duration (hours)
1.5

Lesson Objectives

Oracle Database 11g: Performance Tuning Methodology and Tools

  • identify the steps in both the general and Oracle tuning methodologies
  • identify the characteristics of effective tuning goals
  • recognize the three types of performance data gathered by diagnostic tools
  • recognize the factors to consider when tuning DB time
  • recognize how to use the time model to diagnose performance issues
  • recognize how to view diagnostic information in Enterprise Manager
  • recognize how you can use dynamic performance to view statistics
  • recognize how to use dynamic performance views to display wait events
  • recognize how to use Alert Logs to perform tuning
  • identify ways to generate user trace files
  • view diagnostic information in a given scenario
  • Course Number:
    od_odpt_a01_it_enus