• Home
• Course Catalogue
• Certifications
• Onsite Training
• Scheduled Training
• E-Learning
• Managed Services
• Consulting
• Company
• Special Offers
• News
• Links
• Enquiry And Feedback Form

Training Course Outline

IT Vendor Courses   Oracle DBA Training Courses

Oracle Database 10g DBA Performance & Tuning

View course dates

Course Duration: 3 days

Course Code: O10GDBAPT

Course Description:

This three day training course introduces the main concepts of Oracle performance tuning and will offers practical experience in analyzing and tuning database performance. It also covers the identification of tuning contentions and the application of corrective action.

 

Course Objectives

 

On completing the courese, 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

 

Who Should Attend

 

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

Prerequisites:

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

This course includes the following modules:

Course Content

• 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

 

Location	Duration	RRP	Dec	Jan	Feb	Mar	Apr	May
Click on course date to make a booking, check availability, or find out about available discounts.
London	3 days	£995			2 - 4	16 - 18		11 - 13

<< Previous 6 Months

Next 6 Months >>

Perpetual Solutions are a global provider of onsite training solutions throughout London, UK and the rest of the world. For scheduled training our UK partner network provides an unrivalled choice of courses.

Save as PDF

Print this course