Oracle Performance Tuning

This tutorial will provide a good foundation of Oracle performance tuning along with handy tips for issue resolution.

4.45 (475 reviews)
Udemy
platform
English
language
Databases
category
instructor
2,574
students
3 hours
content
Jan 2017
last update
$44.99
regular price

What you will learn

By the end of this course, you will have good idea about various performance issues with Oracle database. This course provide comprehensive material for the performance tuning including:

• Common Causes of performance issues.

• Places to check for performance issues.

• Approach to resolve performance issues.

• Performance tuning resolution tips.

• SQL tuning, Instance tuning and miscellaneous tuning techniques.

Description

You will get a conceptual understanding of various Oracle database performance issues and learn about different places to check for the performance information along with tuning approach.

Broadly this course will cover following:

1. What are common oracle database performance issues?

2. Where to check for messages / tuning information to get to bottom of issue.

3. Different tuning approaches - based on different databases (OLTP vs Data Warehouse).

4. Learn about database statistics, optimizer and maintenance plan for tables and indexes.

5. SQL and Instance tuning details.

6. General guidelines for avoiding performance issues in Oracle database.

Content

Introduction

Introduction and Course Layout

Performance Tuning Overview

Common Causes of Performance Tuning
Different Approach
Performance Tuning Methodology
Baseline

Sources of Tuning Information

Alert Log
Trace Files
Automatic Workflow Repository
Application Tracing and Performace Tuning views

Understanding Database Statistics

Database Statistics
Oracle Optimizer
Fragmentation and Maintenance Plan

SQL Tuning

TKPROF
Explain Plan, Autotrace and General Guidelines of SQL Tuning

Instance Tuning

Instance Tuning

Miscellaneous Tuning Techniques

Plan Stability and Partition

Demo

Lock and waits demo
Index Demo
Autotrace Demo

Screenshots

Oracle Performance Tuning - Screenshot_01Oracle Performance Tuning - Screenshot_02Oracle Performance Tuning - Screenshot_03Oracle Performance Tuning - Screenshot_04

Reviews

Miguel
April 4, 2021
It is a good knowledge in a terical way on how we can tune database up! It would be better including Demo, Examples on how can I diagnose and how interpret the views, tables, etc. Thanks
Gene
May 3, 2017
I loved the deep dive into how the oracle internals affect performance. I was hoping to see more about how an applications person could analyze performance, specifically interpreting explain plans. Overall it was a very good course.
Emeline
April 2, 2017
There are some explanations that are left out in the lectures. The explanations he gives talking make more sense that those on the lecture slides.
Abhilash
January 23, 2017
The course has good content, and the trainer is also knowledgeable. However the course was too basic, and it would be more suitable for Associate DBA with minimum or no performance tuning experience. The performance tuning concepts of all the key areas were well explained. I was looking for a practical approach, which was lacking in the course. The course is not suitable for all levels as mentioned earlier. I could not pick up anything new in the course, it was the same information as when I initially started my career as a DBA many years before. However I appreciate the trainer uploading the few demos upon request and the efforts that was put into the course, however it was not satisfactory to my expectations.
Sunil
January 8, 2017
Without the lab it is not a complete course. I found the material very good, but as a presenter, he should not directly read from slides. It is certainly a good start.
Gilbert
January 2, 2017
No proper valuable and workable information. He should make a scenario of trying to tune a bad SQL and solving any performance problem. He was just talking and showing slides.
Jorge
December 13, 2016
There is no practical exercises, just slides with superficial content. The teacher's english is not that good and it was recorded using a bad mic (I was not able to use my headphone because of the low volume). It is good if you plan to use it to get asleep.
Leonard
November 27, 2016
He took a difficult and not so defined concept and presented it in a work flow manner that can easily be grasped and handled by any learner.
Luis
July 2, 2016
No in depth explanations, documentation to resources for further research and follow up if needed, nor to support claims made or knowledge. Mostly reading off the slides.
Ugo
March 27, 2016
Plain Powerpoint presentation all the way until the end. Content is relevant not not a whole lot different from a blog post.
Sm2501
January 15, 2016
I really enjoyed this course and would happily recommend it to people looking to learn Oracle performance tuning. The instructor know the subject material well and deliver it in a way that is really engaging and very useful concepts are covered here.
Chris
November 13, 2015
It's very good content but there are very few examples. I would like to see more content and demo..... That will make the material stick. With only lecture and a few bullet points, its more challenging to put what you learn to work
Riya
September 21, 2015
Methodology is not efficient, cannot capture the audiance attention by just showing the same screen and reading at the background. Screens need to be more illustrative and more interactive need more slides and example.
Ing.
January 28, 2015
I'm not so familiar with database tuning, but after this course my mind was opened to a complete and amazing world, with several opportunities! Thanks a lot !
Robert
July 14, 2014
Signal to noise ration is practically 100%. Good use of time to take this course. It really opens your eyes as to what is involved in Oracle Performance Tuning and what an Oracle Performance Tuning professional does for a living.

Charts

Price

Oracle Performance Tuning - Price chart

Rating

Oracle Performance Tuning - Ratings chart

Enrollment distribution

Oracle Performance Tuning - Distribution chart
132138
udemy ID
12/11/2013
course created date
10/16/2020
course indexed date
Bot
course submited by