Nice
Oracle DBA Performance Tuning Course
Learn to tune Oracle databases, identify performance problems, analyze performance data & make performance improvements.
Development,Databases,Databases Other
Lectures -54
Duration -11.5 hours
30-days Money-Back Guarantee
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
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
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
Simple and 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.
Course Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Feedbacks
nice
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe nowOnline Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now