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