Get the most out of your 10g Database by learning performance tuning methods that maximize the utility of the database. Students learn how to benefit from Oracle Database 10g automatic tuning features, as well as practicing the manual tuning methods using the statspack tool. After clearly defining the various methodologies one can use to tune an Oracle Database, the course covers the various tunable components of an Oracle Database. Throughout the course, students experience hands-on the tuning of an Oracle Database by practicing through a series of workshops.

Target Audience
Database Administrators Support Engineer Technical Consultant

Key Topics

• Performance Tuning Overview
• Statistics and Wait Events
• Metrics, Alerts, and Baselines
• Using Statspack
• Using AWR
• Reactive Tuning
• Tuning the Shared Pool
• Tuning the Buffer Cache
• Automatic Shared Memory
• Checkpoint and Redo Tuning
• Tuning I/O
• Tuning PGA and Temporary Space
• Tuning Block Space Usage
• Initial Configuration

Objectives

• Use the Oracle Database tuning methodology appropriate to the available tool
• Utilize database advisors to proactively tune an Oracle database
• Use the tools based on the Automatic Workload Repository to tune the database
• Use Statspack reports to tune the database
• Diagnose and tune common database performance problems
• Use Enterprise Manager performance-related pages to monitor an Oracle database

Required Skills/Experience

• Knowledge of Database Administration
• Oracle Database 10g: Administration Workshop I Release 2
• Oracle Database 10g: Administration Workshop II Release 2
• Oracle Database 10g: New Features for Administrators Release 2

Suggested Next Course(s)

• Oracle Enterprise Manager 10g Grid Control
• Oracle Enterprise Manager 10g Grid Control Release 2
• Oracle Database 10g: SQL Tuning Workshop
• Oracle Database 10g: Real Application Clusters

Fee: $2,400.00

Course Schedule:
Back to Course Description

Austin

Please contact your sales representative for availability.

Charlotte

• Mar 16 - Mar 19

Columbia

• Dec 02 - Dec 05
• Mar 09 - Mar 12

Hunt Valley

Please contact your sales representative for availability.

Lansing

• Mar 16 - Mar 19

Madison

Please contact your sales representative for availability.

Milwaukee

• Jan 19 - Jan 22

Minneapolis

Please contact your sales representative for availability.

Oak Brook

Please contact your sales representative for availability.

Oklahoma City

Please contact your sales representative for availability.

Phoenix

Please contact your sales representative for availability.

Raleigh

Please contact your sales representative for availability.

San Antonio

• Jan 26 - Jan 29

Schaumburg

Please contact your sales representative for availability.

Tulsa

Please contact your sales representative for availability.

Washington DC

• Mar 02 - Mar 05