Training

How We Are Different

Course Summaries

Course Logistics

Private Classes

Request for Information

Course Surveys

 

 
Performance Tuning Oracle and RAC on Linux & UNIX

Overview

This class is designed for the DBA, system administrator, developer, or technical consultant who wishes to learn how to tune Oracle databases on the Linux or UNIX operating systems for maximum performance. Students will become proficient in all aspects of Oracle database performance tuning, this includes database and instance tuning, and SQL tuning. The hardware and software interactions that affect Oracle database performance are also covered in this course and include tuning the operating system, Oracle I/O and storage area networks. Hands-on lab exercises will be used to reinforce key Oracle performance tuning concepts.

Course Objectives

This class is designed to provide instruction in all aspects of tuning Oracle performance on Linux or UNIX operating systems on a storage area network (SAN).

At the end of this course, students will gain knowledge in the following topics:
  • Plan an Oracle database installation for optimum performance
  • Identify performance bottlenecks at the hardware, OS, database, instance, and application levels
  • Monitor database performance using Oracle Enterprise Manager or Statspack
  • Diagnose performance problems with Oracle tools
  • Perform tuning tasks with Oracle Enterprise Manager and the command line
  • Configure the Linux or UNIX OS kernel parameters for optimum performance
  • Identify and resolve I/O, data storage and database configuration problems
  • Control resource usage with Resource Manager
  • Use the diagnostic tools to gather information about SQL statement processing

Course Agenda

  • Overview of Oracle Database Performance Tuning
  • Defining an Effective Tuning Strategy
  • Linux or UNIX Configuration and Tuning for Oracle
  • Tuning SAN I/O for Oracle
  • Diagnostic and Tuning Tools
  • Tuning the Shared Pool
  • Tuning the Buffer Cache
  • Dynamic Instance Resizing
  • Sizing Other SGA Structures
  • Tuning the Oracle Shared Server
  • Optimizing Sort Operations
  • Using Resource Manager
  • SQL Statement Tuning
  • Optimizer Operations
  • Managing Statistics
  • Using Oracle Blocks Efficiently
  • Using Oracle Data Storage Structures Efficiently
  • Tuning Indexes
  • Application Tuning
  • Using Materialized Views
  • Monitoring and Detecting Lock Contention
  • Introduction to Oracle RAC
  • Oracle RAC Performance Tuning
  • Using the Oracle Parallel Query Option

Prerequisites

Successful completion of an Oracle Administration class and previous Oracle SQL training is recommended.

Lab Work

This course includes hands-on labs and workshops where the student can become familiar with performance tuning on live Oracle databases.

Delivery

For more information about scheduling this course or other offerings, please call us at: 1 (800) 887-4513, or e-mail us at: 		 
 

Performance TuningŪ Corporation All Rights Reserved
Performance TuningŪ is a Registered Trademark of Performance TuningŪ Corporation
Tune Right - Run FastŪ is a Trademark of Performance TuningŪ Corporation