HOT
blank

Oracle Database Performance Tuning

IT & Software

Rating4.7
Enroll Now

Oracle Database Performance Tuning, available at $44.99, has an average rating of 4.65, with 264 lectures, based on 468 reviews, and has 2590 subscribers.

You will learn about Oracle database performance tuning This course is ideal for individuals who are Oracle DBAs It is particularly useful for Oracle DBAs.

Enroll now: Oracle Database Performance Tuning

Summary

Title: Oracle Database Performance Tuning

Price: $44.99

Average Rating: 4.65

Number of Lectures: 264

Number of Published Lectures: 264

Number of Curriculum Items: 264

Number of Published Curriculum Objects: 264

Original Price: $44.99

Quality Status: approved

Status: Live

What You Will Learn

  • Oracle database performance tuning

Who Should Attend

  • Oracle DBAs

Target Audiences

  • Oracle DBAs

Do you want to join the 1% DBAs who really know how to achieve the Oracle Database Performance Tuning activities?

Have you ever been called for a slow database or a sluggish session and you did not know where to start?

Are you wondering how you can predict if the database will face a performance issue soon?

If yes, then you are in the right place.

The course does not only demonstrate the Oracle database performance tuning concepts, you will gain hands-on experience on using the performance tuning tools.

The skills that you will learn in this course include the following:

  • Determine the bottlenecks in low-performance Oracle databases

  • Use Oracle database performance tuning tools, like: AWR, ASH, V$ views, SQL tracing, real-time monitoring, and EM Express

  • Propose solutions to database performance issues

  • Implement Oracle methodology in performance tuning

Content and Overview
Information presented in this course provides the Oracle DBAs the knowledge and experience to perform Oracle databases performance tuning activities.

After every concepts lecture, you will implement practical exercises. To guide you on implementing the practices, the practice lectures are supported by video-based demonstrations and the downloadable guide documents.

Starting with introducing Oracle database performance tuning, this course will take you all the away from basics of using Oracle database performance tuning tools up to to propose solutions to performance issues.

You will understand how Oracle methodology works and learn how to implement it.

This course will cover all the complicated topics that are included in Oracle database performance tuning topic, such as the following:

  • Oracle performance statistics, wait events, and metrics

  • Oracle performance tuning tools, like: AWR, ASH, V$ views, SQL tracing, and EM Express

  • Tuning Oracle database components

  • Tuning database consumption from system resources: CPU, memory, disk I/O, and network

  • Managing in-production tables and indexes for performance

  • SQL Performance Analyzer

  • Database Replay

This training session is entirely about making Oracle database more efficient, understanding the root causes of performance problems, and suggest solutions to resolve them.

Instead of thinking of increasing system resource as a first “tuning” choice, this course teaches you about identifying the bottleneck and revive them.

Finally, this course is not just a list of “tips and tricks”, it will go deep into topic. It gives you the knowledge and tools for systematic Oracle database performance tuning.

Take this opportunity and join the author in exploring Oracle Database Performance Tuning skills!

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introducing the Course

Chapter 2: Practice 1 – Preparing Practice Environment

Lecture 1: Practice 1 – Preparing Practice Environment 2 of 7

Lecture 2: Practice 1 – Preparing Practice Environment 1 of 7

Lecture 3: Practice 1 – Preparing Practice Environment 3 of 7

Lecture 4: Practice 1 – Preparing Practice Environment 4 of 7

Lecture 5: Practice 1 – Preparing Practice Environment 5 of 7

Lecture 6: Practice 1 – Preparing Practice Environment 6 of 7

Lecture 7: Practice 1 – Preparing Practice Environment 7 of 7

Chapter 3: Introduction to Oracle Database Performance Tuning

Lecture 1: Introduction to Oracle Database Performance Tuning 1 of 3

Lecture 2: Introduction to Oracle Database Performance Tuning 2 of 3

Lecture 3: Introduction to Oracle Database Performance Tuning 3 of 3

Chapter 4: About Performance Tuning in IT Systems

Lecture 1: About Performance Tuning in IT Systems 1 of 2

Lecture 2: About Performance Tuning in IT Systems 2 of 2

Chapter 5: Introduction to Oracle Database Performance Tuning Tools

Lecture 1: Introduction to Oracle Database Performance Tuning Tools

Chapter 6: Using Time Model

Lecture 1: Using Time Model 1 of 3

Lecture 2: Using Time Model 2 of 3

Lecture 3: Using Time Model 3 of 3

Lecture 4: Practice 2 -Using Time Model 1 of 2

Lecture 5: Practice 2 -Using Time Model 2 of 2

Chapter 7: Using Instance Activity Statistics

Lecture 1: Using Instance Activity Statistics 1 of 2

Lecture 2: Using Instance Activity Statistics 2 of 2

Chapter 8: Wait Events

Lecture 1: Wait Events 1 of 3

Lecture 2: Wait Events 2 of 3

Lecture 3: Wait Events 3 of 3

Lecture 4: Practice 3 – Viewing Instance Activity and Wait Events 1 of 3

Lecture 5: Practice 3 – Viewing Instance Activity and Wait Events 2 of 3

Lecture 6: Practice 3 – Viewing Instance Activity and Wait Events 3 of 3

Chapter 9: Using AWR

Lecture 1: Overview to Automatic Workload Repository (AWR)

Lecture 2: Managing AWR Snapshots 1 of 3

Lecture 3: Managing AWR Snapshots 2 of 3

Lecture 4: Managing AWR Snapshots 3 of 3

Lecture 5: Practice 4 – Managing Automatic Workload Repository (AWR) 1 of 2

Lecture 6: Practice 4 – Managing Automatic Workload Repository (AWR) 2 of 2

Lecture 7: Using AWR Reports 1 of 9

Lecture 8: Using AWR Reports 2 of 9

Lecture 9: Using AWR Reports 3 of 9

Lecture 10: Using AWR Reports 4 of 9

Lecture 11: Using AWR Reports 5 of 9

Lecture 12: Using AWR Reports 6 of 9

Lecture 13: Using AWR Reports 7 of 9

Lecture 14: Using AWR Reports 8 of 9

Lecture 15: Using AWR Reports 9 of 9

Lecture 16: Using AWR Comparison Reports

Lecture 17: Practice 5 – Using AWR Reports 1 of 6

Lecture 18: Practice 5 – Using AWR Reports 2 of 6

Lecture 19: Practice 5 – Using AWR Reports 3 of 6

Lecture 20: Practice 5 – Using AWR Reports 4 of 6

Lecture 21: Practice 5 – Using AWR Reports 5 of 6

Lecture 22: Practice 5 – Using AWR Reports 6 of 6

Lecture 23: Practice 6 – Using AWR SQL Reports

Lecture 24: Managing AWR Baselines

Lecture 25: Managing AWR Baseline Templates 1 of 2

Lecture 26: Managing AWR Baseline Templates 2 of 2

Lecture 27: Practice 7 – Using AWR Baselines and Baseline Templates

Chapter 10: Metrics, Event Histograms and Server-generated Alerts

Lecture 1: Metrics and Event Histograms 1 of 2

Lecture 2: Metrics and Event Histograms 2 of 2

Lecture 3: Server-generated Alerts 1 of 2

Lecture 4: Server-generated Alerts 2 of 2

Lecture 5: Practice 8 – Using Server-generated Alerts 1 of 2

Lecture 6: Practice 8 – Using Server-generated Alerts 2 of 2

Lecture 7: Adaptive Thresholds

Chapter 11: Using Statspack

Lecture 1: Using Statspack 1 of 4

Lecture 2: Using Statspack 2 of 4

Lecture 3: Using Statspack 3 of 4

Lecture 4: Using Statspack 4 of 4

Lecture 5: Practice 9 – Using Statspack 1 of 2

Lecture 6: Practice 9 – Using Statspack 2 of 2

Chapter 12: Using Automatic Database Diagnostic Monitor (ADDM)

Lecture 1: Using Automatic Database Diagnostic Monitor (ADDM) 1 of 3

Lecture 2: Using Automatic Database Diagnostic Monitor (ADDM) 2 of 3

Lecture 3: Using Automatic Database Diagnostic Monitor (ADDM) 3 of 3

Lecture 4: Using ADDM Comparison Report 1 of 2

Lecture 5: Using ADDM Comparison Report 2 of 2

Lecture 6: Practice 10 – Using Automatic Database Diagnostic Monitor (ADDM) 1 of 2

Lecture 7: Practice 10 – Using Automatic Database Diagnostic Monitor (ADDM) 2 of 2

Chapter 13: Using Active Session History (ASH)

Lecture 1: Using Active Session History (ASH) 1 of 3

Lecture 2: Using Active Session History (ASH) 2 of 3

Lecture 3: Using Active Session History (ASH) 3 of 3

Lecture 4: Querying ASH 1 of 4

Lecture 5: Querying ASH 2 of 4

Lecture 6: Querying ASH 3 of 4

Lecture 7: Querying ASH 4 of 4

Lecture 8: Practice 11 – Using Active Session History (ASH) 1 of 4

Lecture 9: Practice 11 – Using Active Session History (ASH) 2 of 4

Lecture 10: Practice 11 – Using Active Session History (ASH) 3 of 4

Lecture 11: Practice 11 – Using Active Session History (ASH) 4 of 4

Lecture 12: Practice 12 – Linking ASH to Its Dimension Views 1 of 4

Lecture 13: Practice 12 – Linking ASH to Its Dimension Views 2 of 4

Instructors

Rating Distribution

  • 1 stars: 12 votes
  • 2 stars: 4 votes
  • 3 stars: 31 votes
  • 4 stars: 137 votes
  • 5 stars: 284 votes

Frequently Asked Questions


How long do I have access to the course materials?


You can view and review the lecture materials indefinitely, like an on-demand channel.


Can I take my courses with me wherever I go?


Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

You may also like

Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024

Top 10 Smart Home Technology Courses to Learn in November 2024

Top 10 Agile Methodologies Courses to Learn in November 2024