|
Training
How We're Different
Course Summaries
Course Logistics
Client-site Classes
Virtual Classes
FAQ
Cancellation Policy
Request 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
- A skill level equivalent to an Oracle DBA, or familiarity with administering an Oracle 10g or 11g database instance
- Basic UNIX/Linux operating system navigation skills, including the ability to use ls, cd, and pwd commands
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:
| |
