Oracle Database Performance Tuning - Fundamentals

Name: Oracle Database Performance Tuning - Fundamentals
Rating: 4.5 (837 reviews)

Concepts of Performance Tuning

Created byTISYA Software Solutions Private Limited, Ramkumar Swaminathan

Last updated 10/2018

English

What you'll learn

Understand basic concepts related to performance tuning

Course content

1 section • 19 lectures • 2h 25m total length

Introduction3:02
Is Managing Performance Easy3:49
That one thing that fixes all performance issues2:03
What to expect in this course3:29
What is Performance Engineering7:40
What is Troubleshooting4:28
What is Performance Management1:01
Is it Luck or Chance?1:23
What is in your BOWL?5:22
Bad Connections and SQL4:44
Understand SQL Response TIme3:00
Defining DB Time3:55
Space Management12:59
Pack Rows Tightly4:35
What should be the Block Size?7:43
Introduction to AWR5:26
What is an AWR Report?3:26
Session 1 -Some case studies to understand performance problems35:45
Session 11 - Alternate Storage Techniques and Indexes Overview31:22

Requirements

Oracle Database Architecture knowledge

Description

In this course you will learn about the fundamentals concepts and terms about tuning and troubleshooting Oracle Databases. This is a free course, to get more details you can take the course on Oracle Database Troubleshooting and Tuning . That course goes into more details about reading and interpreting an AWR report and gives you more information.

Who this course is for:

Anyone interested to troubleshoot and tune an Oracle database