Oracle 10g - DBA Performance Tuning

One of the biggest responsibilities of a DBA is to ensure that the Oracle database is tuned properly. The Oracle RDBMS is highly tunable and allows the database to be monitored and adjusted to increase its performance.

One should do performance tuning for the following reasons:

  • The speed of computing might be wasting valuable human time (users waiting for response)
  • Enable your system to keep-up with the speed business is conducted; and
  • Optimize hardware usage to save money (companies are spending millions on hardware).

Although this site is not overly concerned with hardware issues, one needs to remember than you cannot tune a Buick into a Ferrari.

Why Oracle in Mazenet

  • Mazenet is the authorized Oracle corporation to deliver Oracle product.
  • Mazenet is the Oracle WDP(Workforce development Program) so we provide Oracle E-kit.
  • Mazenet offers 25% discount vouchers on any oracle globally certified examinations.
  • Mazenet provide the Oracle Course Completion certificate only and no mazenet certifications.
  • Mazenet deliver the syllabus mapped by the Oracle Corporation.
  • Mazenet offers the value added informations about Oracle 11g features after completing Oracle 10g DBA.
  • Mazenet provides Oracle 11g tool kits to deliver the program.
  • Mazenet delivers the examinations directly through the Oracle Corporation.

Course Objective:

  • 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

Oracle 10g - DBA Performance Tuning Training Outline

  • 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