Oracle Database 10g: Performance Tuning

Beschreibung

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.

Zielgruppe

Datenbankadministratoren, Technischer Berater

Voraussetzungen

Kenntnisse der Datenbank Administration Oracle Database 10g: Administration Workshop I Rel 2 Oracle Database 10g: Administration Workshop II Rel 2 Oracle Database 10g: New Features for Administrators Release 2

Kursinhalte

• 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