Oracle Database 10g DBA Performance & Tuning
Course
In London
Description
-
Type
Course
-
Location
London
-
Duration
4 Days
Delegates will be introduced to the main concepts of Oracle performance tuning and will gain practical experience in analyzing and tuning database performance. They will learn to identify tuning contentions and be able to take corrective action. By the end of the course, delegates will be able to: Use different tuning methodologies Use the database advisors to proactively tune. Suitable for: Database administrators, application developers and technical support staff who are required to monitor and tune Oracle Database 10g.
Facilities
Location
Start date
Start date
About this course
A working knowledge of Oracle SQL*Plus and Oracle Database Administration. This can be obtained by attendance on the pre-requisite courses.
Reviews
Course programme
Database administrators, application developers and technical support staff who are required to monitor and tune Oracle Database 10g.
Objectives:
Delegates will be introduced to the main concepts of Oracle performance tuning and will gain practical experience in analyzing and tuning database performance. They will learn to identify tuning contentions and be able to take corrective action. By the end of the course, delegates 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
Topics Covered:
- 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
- Materialized views
- Parallel DML
Requirements:
A working knowledge of Oracle SQL*Plus and Oracle Database Administration. This can be obtained by attendance on the pre-requisite courses.
Oracle Database 10g DBA Performance & Tuning