On-site & Public, Instructor-led, Hands-on IT Training
800.756.3000
(International 01) 908.233.8900
  400+ Course Offerings:


Search for Course:

OR5490 Oracle Database Performance Tuning for Administrators
 
 
Duration 4 Days
Delivery Method Instructor Led, Hands-on Workshops
Public Price $2100.00


DESCRIPTION (Return to Top)

In this course students will clearly define the various methodologies one can use to tune an Oracle Database. The course covers the various components of an Oracle Database where potential performance bottlenecks could occur and how to monitor and tune them.

Throughout the course, students experience hands-on exercises in tuning a database.



AUDIENCE (Return to Top)

Oracle Database Administrators (DBAs)



OBJECTIVES (Return to Top)

Upon successful completion of this course, the student will be able to:

  • Identify the potential performance bottlenecks in an Oracle database
  • Understand which database parameters are important to performance
  • Query various data dictionary and dynamic performance views for performance information
  • Use various utilities to help diagnose database performance problems
  • Understand and use the database advisors
  • Set up an Oracle database for efficient performance


TOPICS (Return to Top)
  • Database Tuning Overview
  • Database Architecture
  • Automatic Memory Management (AMM and ASMM)
  • Tuning the Shared Pool
  • Tuning the Buffer Cache
  • Tuning PGA and Temporary Space
  • Checkpoint and Redo Tuning
  • Tuning Block Space Usage
  • Statistics and Wait Events
  • The Automatic Workload Repository (AWR) and the Advisory Framework
  • Additional SQL Tuning Topics
  • Miscellaneous Tuning Tips


PREREQUISITES (Return to Top)

OR5510 Oracle Database Administration or Oracle DBA experience.