Oracle Database 10g: Performance Tuning (D19165GC10)


  • 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.
  • This course counts towards the Hands-on course requirement for the Oracle Database 10g Administrator Certification. Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses are excellent study and reference tools but DO NOT meet the Hands-on Requirement for certification.


Course Code:




  • Knowledge of Database Administration
  • Oracle Database 10g: Administration Workshop I
  • Oracle Database 10g: Administration Workshop II Release 2
  • Oracle Database 10g: New Features for Administrators Release 2

  • 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

  • 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
Target Audience

  • Database Administrators
  • Support Engineer
  • Technical Consultant
vendors Course Code Course Title Days Date
Oracle Certifications in UAE
O10GPT Oracle Database 10g: Performance Tuning (D19165GC10) 4 View All Dates

This public courses are pre-scheduled throughout the year at our premises

Online, live and interactive training accessible from anywhere

We can deliver standard or customised training at any time and location that suits your employees

Guaranteed courses are confirmed to run on the specific dates shown