On-line training course catalogue
Oracle Database 10g: Performance Tuning
Type of course: Classroom
| Fee | £1760 |
|---|---|
| Days | 4 |
| Course code | OR10GPT |
| Location | Aug | Sep | Oct | Nov | Dec | Jan |
|---|---|---|---|---|---|---|
| Altrincham Manchester | |- | |29 | |- | |- | |- | |- |
| Leeds Yorkshire | |- | |- | |- | |3 | |- | |- |
| London King William Street | |- | |- | |6 | |- | |- | |- |
Booking: click a course date | View location: click location name | Print this page | Download as Word document |
Overview
Please note that Oracle courses running at London training centres are subject to a 5% surcharge.
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.
Prerequisites
Knowledge of Database Administration and attendance at the following three courses :-
- Oracle Database 10g: Administration Workshop I
- Oracle Database 10g: Administration Workshop II
- Oracle Database 10g: New Features for Administrators Release 2
Delegates will learn how to
- 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
- 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
Suggested Next Courses
- Oracle Database 10g: SQL Tuning Workshop
- Oracle Database 10g: Real Application Clusters
- View all Oracle 10g courses
Link to this page: http://www.xpertise.co.uk/OR10GPT
Xpertise – Oracle Database 10g: Performance Tuning training courses
Xpertise provides Oracle Database 10g: Performance Tuning training courses from 7 UK locations: in Altrincham Manchester, Hinckley East Midlands, Leeds Yorkshire, London King William Street, Maidenhead Berkshire, Malmesbury Wiltshire and Washington Tyne & Wear – and at 44 partner locations nationwide.
Xpertise Training reserves the right to improve the specification and format of its courses for the benefit of its customers without notice to the customer.