Type
Virtual
Classroom ILT
Skill Level

Available dates
Learning Path
Virtual
Duration
1 Day

TYPE
Virtual
Classroom ILT
LEARNING PATH
SKILL LEVEL

DURATION
AVAILABLE DATES
Introduction:
Students learn how to use Oracle Database 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 and operation performance, and tuning the Oracle Database Instance components.
Audience profile:
This course is intended for:
- Administrator
- Database Administrator
Pre-requisites:
Before attending this course, students must have: Suggested Prerequisite
- Oracle Database: Deploy, Patch and Upgrade Workshop
- Familiarity with Oracle Database installation
- Familiarity with Oracle Database configuration concepts Required Prerequisite
- Oracle Database: Administration Workshop
- Basic knowledge of Linux operating system
- A working knowledge of SQL and PL/SQL packages
- Basic understanding of Oracle Database architecture
- Familiarity with basic database monitoring procedures
Course objectives:
After completing this course, students will be able to:
- Use the Oracle Database tuning methodology appropriate to the available tools
- Utilize database advisors to proactively tune an Oracle Database Instance
- Use the tools based on the Automatic Workload Repository to tune the database
- Diagnose and tune common SQL related performance problems
- Diagnose and tune common Instance related performance problems
- Use Enterprise Manager performance-related pages to monitor an Oracle Database
Lesson 1: Introduction |
Lesson 2: Basic Tuning Diagnostics |
Lesson 3: Using Automatic Workload Repository |
Lesson 4: Defining the Scope of Performance Issues |
Lesson 5: Using Metrics and Alerts |
Lesson 6: Using Baselines |
Lesson 7: Using AWR-Based Tools |
Lesson 8: Real-Time Database Operation Monitoring |
Lesson 9: Monitoring Applications |
Lesson 10: Identifying Problem SQL Statements |
Lesson 11: Influencing the Optimizer |
Lesson 12: Reducing the Cost of SQL Operations |
Lesson 13: Using SQL Performance Analyzer |
Lesson 14: SQL Performance Management |
Lesson 15: Using Database Replay |
Lesson 16: Tuning the Shared Pool |
Lesson 17: Tuning the Buffer Cache |
Lesson 18: Tuning PGA and Temporary Space |
Lesson 19: Automatic Memory |
Lesson 20: Performance Tuning Summary with Waits |
Torque IT specializes in providing our Clients with Vendor authorized instructor-led training, enablement IT courses, and certification solutions.
Associated certifications and exam:
On successful completion of this course students will receive an Oracle University attendance certificate.

Oracle Overview
Torque IT considers authorised Oracle training to be an integral part of any Oracle Solaris, Oracle Enterprise Linux, Oracle Applications, Java development, or Oracle Database implementation. Oracle authorized training, and associated certification, ensures that you get the most from your technology investment and that you are able to operate above the technology curve.
Our instructor led training provides customers with a hands-on experience to match job role requirements and prepares delegates for Oracle Certification exams. From in-class demonstrations to hands-on-labs, Torque IT’s authorised Oracle instructor led training provides our customers with a comprehensive and dynamic learning experience.
Oracle certifications are universally recognized as demonstrating a high level of expertise and credibility for individuals and the organizations that employ them. Authorised Oracle training and certification is the industry standard for any solution that includes designing, selling, implementing, upgrading, developing and managing Solaris, Java, and Oracle Database solutions.
Torque IT is recognised by Oracle as an Oracle University Training Centre which means that we offer our clients internationally recognised and globally accredited Oracle training and certification. These achievements reflect our commitment to providing our customers with quality skills development, enablement, training, and certification solutions that demonstrate exceptional depth, breadth, and expertise.
Torque is recognised by Oracle, and the industry, as having met rigorous standards for educational competency, service, customer satisfaction and investment in technology that will prepare the next generation of IT industry professionals to exploit Oracle Solutions.