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:
In the Oracle Database 12c: Performance Management and Tuning course, learn about the performance analysis and tuning tasks expected of a DBA. In this course, you will be introduced to Oracle Database Cloud Service.
Audience profile:
This course is intended for:
- Database Administrators
- Data Warehouse Administrator
Pre-requisites:
Before attending this course, students must have:
- CO-78846: Oracle Database 12c: Administration Workshop Ed 2
- CO-77766: Oracle Database 12c: Install and Upgrade Workshop
Oracle requires and recommends that delegates have attended the following course prior to attending this course:
- CO-81246: Oracle Database 12c R2: Clusterware Administration
- CO-81250: Oracle Database 12c R2: RAC Administration
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
- Gain an understanding of the Oracle Database Cloud Service
Session 1: Introduction | |
|
|
|
|
Session 2: Basic Tuning Diagnostics | |
|
|
|
|
|
|
Session 3: Using Automatic Workload Repository | |
|
|
|
|
|
|
Session 4: Defining the Scope of Performance Issues | |
|
|
|
|
|
|
|
|
Session 5: Using Metrics and Alerts Usage | |
|
|
|
|
|
|
|
|
Session 6: Using Baselines | |
|
|
|
|
|
|
|
|
Session 7: Using AWR-Based Tools | |
|
|
|
|
|
|
|
|
Session 8: Real-Time Database Operation Monitoring | |
|
|
|
|
|
|
Session 9: Monitoring Applications | |
|
|
|
|
|
|
|
|
Session 10: Identifying Problem SQL Statements | |
|
|
|
|
|
|
|
|
Session 11: Influencing the Optimizer | |
|
|
|
|
|
|
|
|
Session 12: Reducing the Cost of SQL Operations | |
|
|
|
|
|
|
|
|
Session 13: Using SQL Performance Analyzer | |
|
|
|
|
|
|
|
|
Session 14: SQL Performance Management | |
|
|
|
|
|
|
|
|
Session 15: Using Database Replay | |
|
|
|
|
|
|
Session 16: Tuning the Shared Pool | |
|
|
|
|
|
|
|
|
Session 17: Tuning the Buffer Cache | |
|
|
|
|
|
|
|
|
Session 18: Tuning PGA and Temporary Space | |
|
|
|
|
|
|
Session 19: Automatic Memory | |
|
|
|
|
|
|
Session 20: Performance Tuning Summary with Waits | |
|
|
|
|
Session 21: Oracle Database Cloud Service: Overview | |
|
|
|
|
|
|
|
|
Associated Certifications & 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.