Oracle DBA Performance Tuning

4.4 ★★★★ ★

Oracle DBA Performance Tuning

Name: Oracle DBA Performance Tuning
Rating: 4.4 (277 reviews)
Author: Tutorialspoint

Learn to tune Oracle databases, identify performance problems, analyze performance data & make performance improvements.

updated on icon Updated on Apr, 2024

language icon Language - English

person icon Tutorialspoint

English [CC]

category icon Development,Databases,Databases Other

Lectures -54

Duration -11.5 hours

4.4 ★★★★ ★

Enroll Course

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

Oracle DBA Performance Tuning course is perfect for anyone who wants to learn how to tune Oracle databases. It is a comprehensive guide that covers everything you need to know, from identifying performance problems to making performance improvements.

Oracle DBA Performance Tuning Course Overview

This course will cover the basics of Oracle performance tuning. It will also cover advanced topics, such as using Oracle tools to analyze performance data and making improvements to the database configuration, the application code, and the hardware. You will also have a solid understanding of the concepts of Oracle databases.

It covers the following topics in detail:

Identifying performance problems: This includes understanding the different types of performance problems, how to collect performance data, and how to analyze performance data.
Analyzing performance data: This includes using Oracle tools to analyze performance data, such as AWR and ASH.
Making performance improvements: This includes making changes to the database configuration, the application code, and the hardware.

Goals

What will you learn in this course:

Teach you how to tune Oracle databases
Give you a solid understanding of the concepts of Oracle performance tuning
Help you develop your skills in Oracle performance tuning
Give you an understanding of Oracle Database Architecture, Performance Tuning Tools e.g. OEM, AWR, ADDM & ASH, Oracle Optimizer, Indexing, Partitions, and memory tuning.

Prerequisites

What are the prerequisites for this course?

This course is for beginners who want to learn how to tune Oracle databases.
No prior experience with Oracle is required.

Curriculum

Check out the detailed breakdown of what’s inside the course

Oracle DB Architecture Tuning Centric
6 Lectures

Software Functionality 09:58 09:58
OS Dependencies 11:55 11:55
Application and Networking Architecture 08:31 08:31
Oracle Database Architecture 16:37 16:37
Memory Dependencies 13:43 13:43
Storage Dependencies 09:14 09:14

Performance Tuning Tools
8 Lectures

Oracle Optimizer
8 Lectures

SQL Tuning with Activities-1
4 Lectures

SQL Tuning with Activities-2
6 Lectures

Real Time Data Loading and Monitoring
1 Lectures

Real Time – AWR Report Analysis
1 Lectures

Reports and Analysis
3 Lectures

Database Storage Objects
5 Lectures

Advisories
1 Lectures

Instance/Memory Real Time Tuning
7 Lectures

I/O Tuning
2 Lectures

Best Architectural Practices
1 Lectures

Instructor Details

Tutorialspoint

Simply Easy Learning

Tutorials Point originated from the idea that there exists a class of readers who respond better to online content and prefer to learn new skills at their own pace from the comforts of their drawing rooms.

The journey commenced with a single tutorial on HTML in 2006 and elated by the response it generated, we worked our way to adding fresh tutorials to our repository which now proudly flaunts a wealth of tutorials and allied articles on topics ranging from programming languages to web designing to academics and much more.

40 million readers read 100 million pages every month

Our Text Library Content and resources are freely available and we prefer to keep it that way to encourage our readers acquire as many skills as they would like to. We don't force our readers to sign up with us or submit their details either to use our Free Text Tutorials Library. No preconditions and no impediments, Just Simply Easy Learning!

We have established a Digital Content Marketplace to sell Video Courses and eBooks at a very nominal cost. You will have to register with us to avail these premium services.