In this course you will learn about how to interpret an AWR report
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
Understand WAIT Events, Interpret an AWR report, Identify alternative solutions to problems and improve database performance...
12 Lectures
3 Lectures
6 Lectures
6 Lectures
7 Lectures
7 Lectures
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...
Have been working on various technologies including Oracle Database and related technologies ( High Availability, RAC and DG, Security, Performance Tuning, Spatial etc) , GoldenGate, Exadata, Enterprise Manager, Oracle Cloud and R. Teaching is a passion and I am doing my best to help people learn and be better at their profession... Please do review my courses and provide list...
Excellent material and delivery
- The course lacks helpfulness and does not justify its price of 1999; it should be priced at a maximum of 499.
- The title of the course, "Oracle DB Tuning & Troubleshooting - Interpret an AWR Report" is misleading; it primarily covers basic fundamentals of AWR.
- Despite expecting deeper insights into performance tuning after watching Ram's YouTube videos, the course merely repeats terms and content, lacking clarity and coherence.
- The course content is disorganized, with recordings often starting abruptly, leading to a sense of missing information.
- Questions from students disrupt the flow of the course, further indicating poor organization.
- The course offers no practical demonstrations of query tuning or reducing elapsed time, omitting crucial aspects of performance tuning.
- Despite Ram's teaching talent, the course feels like a disappointment, lacking explanations on execution plans, query tuning and practical demonstrations. It's not recommended for either beginners or experienced individuals.
Despite feeling very dissatisfied with the course on performance tuning, I would still encourage everyone to consider learning DBA from Ram, as that might prove helpful, even though this particular course falls short in delivering effective performance tuning content.
Yes I see this training is covered the in-depth knowledge :). Thank you.
well explained. Initially course was a drag, and I felt I should go for a refund.
But it picked up very well in the middle. Worth it.
Very good lectures by Ram Sir. I would look forward for your courses which includes how to tune queries and other SQL,PLSQL programs. Please post it.
Great course! Instructor was very knowledgable and material was well presented.
Amazing course. Probably the best on this topic. I would like to learn more about the next section on how to tune based on what we learnt about AWR analysis.
Amazing course which covers internals of Oracle Database and very well explained on Oracle Database Architecture and interpreting on AWR reports. I enjoyed learning in this course. Keep up the good work going. I wish you add training on how to fix the db issues after diagnosing them.
Goodgood
Your email address will not be published. Required fields are marked *
Lizbeth H.
Good content