Oracle Database 10g Performance & Tuning

5 Day Course
Hands On
Code OR10GPT

Book Now - 1 Delivery Method Available:

Scheduled Online Onsite

Overview

This course introduces the main concepts of Oracle performance tuning and offers practical experience in analyzing and tuning database performance.  Delegates will learn to identify tuning contentions and be able to take corrective action.

Course Objectives

On completing the course, you will be able to:

- Use different tuning methodologies
- Use the database advisors to proactively tune a database
- Use AWR tools to tune a database
- Detect and tune common database performance problems
- Use Enterprise Manager to monitor an Oracle database
- Tune applications for optimal performance
- Optimize SQL queries for faster access
- Tune code to reduce disk I/O and network traffic

Who Should Attend

Database administrators, application developers and technical support staff who are required to monitor and tune Oracle Database 10g.

Training Partners

We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.

Modules

Course Content (27 topics)

  • Tuning goals and methodology
  • Common tuning problems
  • Log a SR with Oracle support
  • Statistics and wait events
  • Metrics, alerts and baselines
  • Statspack
  • Automatic Workload Repository
  • Tune the SGA and Shared Pool
  • Tune the data block buffers
  • Automatic Shared Memory Management
  • PGA and temporary space
  • Checkpoint and redo log tuning
  • Manage disk I/O
  • Manage undo information
  • Tune block space
  • Initial database configuration
  • Tuning Database Applications for Optimal Performance
  • Managing Statistics
  • Creating and Using Indexes
  • Creating and Using Views
  • Structuring SQL Statements for Performance
  • Using the SQL Optimizers
  • Examining the Execution Plan of a SQL Statement using EXPLAIN PLAN
  • Examining the Efficiency of SQL Statements using SQL Trace and Autotrace
  • Using Hints to Influence Execution Plan
  • Identifying Unused Indexes
  • PL/SQL Tuning Issues

Prerequisites

A working knowledge of Oracle SQL*Plus and Oracle Database Administration. This can be obtained by attendance on the pre-requisite courses.

Additional Learning

The courses below may help you meet the knowledge level required to take this course. If you are unsure please ask a training advisor .

or call:408-759-5074

Course PDF

Print

Share this Course

+1
Share

Recommend this Course

Sections