IT & Software Other IT & Software Oracle Database

Oracle Database Performance Tuning - Fundamentals

Concepts of Performance Tuning
Rating: 4.2 out of 5 (667 ratings)
13,300 students
Created by TISYA Software Solutions Private Limited, Ramkumar Swaminathan
English
Understand basic concepts related to performance tuning

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

Course content

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

  • Introduction
    03:02
  • Is Managing Performance Easy
    03:49
  • That one thing that fixes all performance issues
    02:03
  • What to expect in this course
    03:29
  • What is Performance Engineering
    07:40
  • What is Troubleshooting
    04:28
  • What is Performance Management
    01:01
  • Is it Luck or Chance?
    01:23
  • What is in your BOWL?
    05:22
  • Bad Connections and SQL
    04:44
  • Understand SQL Response TIme
    03:00
  • Defining DB Time
    03:55
  • Space Management
    12:59
  • Pack Rows Tightly
    04:35
  • What should be the Block Size?
    07:43
  • Introduction to AWR
    05:26
  • What is an AWR Report?
    03:26
  • Session 1 -Some case studies to understand performance problems
    35:45
  • Session 11 - Alternate Storage Techniques and Indexes Overview
    31:22

Instructors

TISYA Software Solutions Private Limited
Technology Learning Services
TISYA Software Solutions Private Limited
  • 4.4 Instructor Rating
  • 4,259 Reviews
  • 37,372 Students
  • 9 Courses

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

- OOAD & UML

- 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!!!!

Ramkumar Swaminathan
Senior Technical Professional
Ramkumar Swaminathan
  • 4.4 Instructor Rating
  • 4,252 Reviews
  • 37,350 Students
  • 8 Courses

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 of interests that you have so that I can publish those courses as well...