Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Oracle DB Tuning & Troubleshooting – Interpret an AWR Report

In this course you will learn about how to interpret an AWR report
(346 reviews)
1,754 students
Created by


CourseMarks Score®







Platform: Udemy
Video: 10h 17m
Language: English
Next start: On Demand

Table of contents


This training will enable participants to learn Advanced Tuning and Troubleshooting techniques for Oracle Databases. It will enable the participants to go beyond standard troubleshooting methods and get to advanced techniques analysis to diagnose performance problems. At the end of the training, you will be able to interpret an AWR report and identify whether there is any problem in your database, and if they exist, what are the top problems / root causes of problems.

Additional resources( slide deck , practice guide etc) are part of Lecture 10.
The topics covered in this course are

Understanding   Database Execution and Resource Utilization
–         CPU, Memory and I/O usage patterns
–         When does the  Database use   what Resource
Design – Why   is it the best and first place to fix Performance Issues
–         Design Fundamentals
–         Data Type
–         Using Constraints
–         Considering Alternate Storage techniques
Will Adding   Hardware solve Performance Issues?
–         Response Time = Service Time + Wait Time
Accurately   Identifying Performance Metrics
–         Understanding the Wait Event Ecosystem
o      Wait Event Fundamentals
o      Diagnosing  Problems based   on  Wait Events
–         Understanding Ratio Analysis
o      Memory Issues
o      I/O Issues
o      Space Issues
Understanding   Physical Design
Optimizing   Storage Configuration
–         Hardware / Disk Optimization ( Understand your Storage)
–         Space Vs IOPS Vs MBPS – What do you ask when you need Storage
–         File placement Strategies – With Striping
How to Read an AWR Report
–         Important Sections of an AWR Report
–         Approach to read an AWR Report
–         Important terms to know to do a 5 minute Analysis and identify the   top issue/ problem
Get the Best out of SGA Memory
–         Tuning Buffer Cache
– Keep/Recycle Pools,   how to configure them
– Using Flash Cache
–         Tuning Shared Pool
–  Why to Share Cursors
–  How to identify if Cursors are Shared
–  Keeping Objects in Shared Pool
–  Using Result Cache
–         Tuning PGA
– Serial Reuseability
– FREE Unused Memory
Identify I/O Hotspots
–         File & Tablespace I/O Statistics
–         Top Objects consuming I/O
Identify Bad SQL
–         What is Bad SQL
–         Is it good to do Disk Reads or Memory Reads
–         Is there a Threshold for Memory and  CPU Consumption
–         What to do after Identifying them

You will learn

✓ Understand WAIT Events, Interpret an AWR report, Identify alternative solutions to problems and improve database performance…


• Understanding of Oracle Database architecture and experience in some tuning activity

This course is for

• DBAs and developers who would like to troubleshoot and tune an Oracle database.
Technology Learning Services
We are a group of senior technical professionals with varied experience in the Software Industry. We started this venture out of a passion to educate people. Our vision is to enable people learn at their own pace & convenience and go to the next level.
By sharing our knowledge & experience in professional videos we want to up-skill individuals and help them meet their learning goals. 

We are experts in technologies given below:
– Oracle Database ( Development, Administration & Tuning)
– Java & JEE ( Development and Tuning)
– JEE Application Servers
– Oracle Engineered Systems
– Big Data ( Hadoop, NoSQL databases, Kafka, Spark …)
– Oracle GoldenGate  & Oracle Data Integrator
– Oracle Spatial
– Data Mining
– Performance Engineering
– R and Analytics
– Oracle Cloud

Our approach/strategy in delivering online training is to bring the class to wherever you are. We believe learning is more effective when the student sees the instructor explaining concepts. We have been teaching Instructor led and Live Virtual Classes across the Globe. We also wanted to make knowledge available online at an affordable cost.
We are sure you will enjoy and learn and look forward to your feedback.
Happy Learning!!!!
Browse all courses by on Coursemarks.
Platform: Udemy
Video: 10h 17m
Language: English
Next start: On Demand

Students are also interested in