Oracle Performance Tuning


Introduction to Oracle  Tuning : 

This section introduces participants to a series of tuning steps that can be used to improve the performance of the Oracle Server. The focus is on database issues rather than specific operating system performance issues. Students will learn how to recognize, troubleshoot, and resolve common performance-related problems in administering an Oracle database.

Learning Objectives - After completing this course, students will be able to :

  • Apply sound database design principles to ensure high performance
  • Identify appropriate metrics and tuning goals for measuring and monitoring performance
  • Identify the critical performance tuning steps
  • Interpret Oracle alert files
  • Use Oracle trace files
  • Use Oracle utilities for performance tuning
  • Use the V$ utilities for tuning
  • Employ tuning techniques for different types of applications

    Course Hours : 40 Hours