Performance Tuning Methodology and Tools in Oracle9i


Overview/Description
To describe the methods and goals of database tuning and the utilities and tools used to analyze and tune an Oracle9i database

Target Audience
Anyone wishing to learn about Oracle9i database performance tuning

Prerequisites
An understanding of database concepts and technologies

Expected Duration
80 Minutes

Objectives:

Performance Tuning Methodology and Tools in Oracle9i

  • discuss the process of database tuning for optimum performance in an Oracle9i database.
  • describe the tools and utilities for analyzing and tuning an Oracle9i database.
  • describe how to install, configure, and run the Oracle9i STATSPACK utility to gather performance statistics.
  • install and configure the Oracle9i STATSPACK utility.

  • Course Number: 70121_eng