Oracle DB Tuning & Troubleshooting - Interpret an AWR Report
3.7 (64 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
176 students enrolled

Oracle DB Tuning & Troubleshooting - Interpret an AWR Report

In this course you will learn about how to interpret an AWR report
3.7 (64 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
176 students enrolled
Price: $49.99
30-Day Money-Back Guarantee
This course includes
  • 10.5 hours on-demand video
  • 3 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Understand WAIT Events, Interpret an AWR report, Identify alternative solutions to problems and improve database performance...
Requirements
  • Understanding of Oracle Database architecture and experience in some tuning activity
Description

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

 

Who this course is for:
  • DBAs and developers who would like to troubleshoot and tune an Oracle database.
Course content
Expand all 41 lectures 10:25:02
+ Understanding Design
3 lectures 01:01:30
Session 3 - Importance of Design - Part 1
19:24
Session 4 - Importance of Design - Part 2
14:29
Session 5 - Connection Management and Connection Pools
27:37
+ Understanding Performance Metrics
6 lectures 01:38:11
Session 6 - Will increasing hardware improve performance?
16:32
Session 7 - Understanding DB TIme and Wait Events - Part 1
31:46
Session 8 - Understanding Wait Events - Part 2
36:33
+ Physical Design and Storage
6 lectures 02:28:20
Session 9 - Wait Events - Part 3 and Understanding Physical Design
28:26
Session 10 - Block Size and Space Management
32:02
Session 11 - Alternate Storage Techniques and Indexes Overview
31:22
Session 12 - Optimizing Storage
35:48
+ Interpreting AWR
7 lectures 02:24:26
Session 13 - Interpreting an AWR Report - Part 1
14:27
Session 14 - Interpreting an AWR Report - Part 2
01:01:18
Session 15 - Interpreting an AWR Report - Part 3
23:32
Session 16 - Interpreting an AWR Report - Part 4
35:00
Session 17 - How about an AWR report across snapshots with an Instance Restart
01:17
+ Getting the best out of the Memory
7 lectures 01:23:17
Session 18 - Optimizing the Buffer Cache
20:29
Session 19 - Understanding the Shared Pool
22:41
Session 20 - PGA tuning and Memory Advisories
16:18
Session 21 - Identifying I/O Hotspots
03:42