Students learn how to use Oracle Database 11g automatic tuning features such as SQL Tuning Advisor, SQL Access Advisor, Automatic Workload Repository and Automatic Database Diagnostic Monitor, and practice these tuning methods. The course focuses on the tuning tasks expected of a DBA: reactive tuning of SQL statements, maintaining SQL statement performance, and tuning the Oracle Database Instance components.
Course Content / Exam(s)
Schedule for Oracle Database 11g: Performance Tuning
Oracle Database 11g: Performance Tuning Benefits
Upon Completion of this Course, you will accomplish following:
Describe Oracle tuning methodology.
Use Oracle supplied tools for monitoring and diagnosing SQL and Instance tuning issues.
Use database advisors to correct performance problems proactively.
Identify problem SQL statements & tune SQL performance problems.
Give an edge to your career with Oracle certification training courses. Students can join the classes for Oracle Database 11g: Performance Tuning Training Course at Koenig Campus located at New Delhi, Bengaluru, Shimla, Goa, Dehradun, Dubai & Instructor-Led Online.
Recommended Courses and Certification: