It provides a key guide to understanding the internal mechanisms of Oracle DB architecture and growing as a performance tuning and performance analysis expert.
Important Basic Knowledge for Configuring a Database
Internal Mechanisms of Oracle Architecture
How to use SwingBench for performance load testing and how to perform load testing
Mechanisms and solutions for various wait events
Oracle Database Performance Tuning
Analysis methodology that allows you to quickly reach the level of a performance analysis expert
Performance Analysis Methodology Using AWR
Detailed individual items of AWR and ADDM Report
Various AWR Analysis Practice on SwingBench Load
AWR Analysis Case of Actual Customer Site
Key know-how provided by DB consultants,
Grow into a differentiated Oracle expert .
The Oracle Performance Analysis and Tuning Essentials Guide provides essential guidance to quickly grow you into an Oracle Database expert consultant .
Becoming an Oracle DB expert requires a lot of time and diverse experiences.
Unfortunately, even if you perform DB maintenance work for a long time, it is often difficult to gain diverse experience due to repetitive tasks, and it is difficult to grow into an expert in the vast world of Oracle DB no matter how long you work without proper DBMS fundamentals .
This course is designed to provide you with the basic knowledge you need to grow as an Oracle DB performance diagnosis/tuning expert, and to help you quickly develop differentiated technical skills in the right direction.
Based on my experience working as an Oracle DB consultant at many customer sites, I have created this lecture centered on the essential core elements to grow as an Oracle DB performance diagnosis and tuning expert, as well as the content that I have guided my fellow consultants to perform performance diagnosis and improvement consulting easily and quickly .
The lecture includes a detailed explanation of the core mechanisms of Oracle architecture and Wait Events, which are essential elements for Oracle performance analysis, a process for diagnosing and improving Oracle performance through AWR, and a methodology for improved DB architecture.
It also consists of many analysis exercises and various analysis cases so that you can acquire Oracle DB performance expertise.
We clearly explain the core Oracle technologies and architecture that you must know for performance analysis and tuning.
Oracle's architecture and functions are so vast that it takes a very long time to learn them all. In addition, it is the main reason why people give up studying Oracle DB because they are caught up in many minor technologies/knowledge .
This course focuses on the basic knowledge and core Oracle architecture that you absolutely need to become a DBMS expert. Based on these DBMS fundamentals, we will help you easily understand and apply core technologies across DBMS.
To understand DB , you need to apply various actual loads and see how the DB's performance indicators change .
To this end, we build a practical environment by configuring an actual database of about 40 GB on an Oracle Cloud VM with 2 CPU Cores and 256 GB SSD Storage, and perform performance diagnosis and analysis practice by applying various types of loads to the practical DB using the SwingBench Benchmark tool.
We also provide detailed information on the optimal methodology for performance analysis and conduct repetitive analysis exercises to ensure that you fully acquire it.
You can learn more in-depth about how to analyze DB performance and architecture issues and suggest solutions based on consulting data analyzed from actual customer sites .
Through this, you will gain a broader understanding of various performance issue cases that may arise during DB operation, and further experience the work performed by DB performance diagnosis/improvement consultants .
This course does not cover SQL tuning.
The practical environment for the lecture is built on Oracle Cloud . Oracle Cloud provides one month of free credit to use Oracle DBMS on 2 core CPU and 250GB SSD.
Source: Oracle official website (click here )
Unfortunately, there is a one-month limitation period . If you do not want Oracle Cloud, there is also a way to use other clouds. For more detailed information, please refer to the Section 0: Lecture Introduction and Lab Environment Configuration video before selecting a lecture .
We provide lecture materials and practice codes of approximately 250 pages.
Practice scripts and lecture materials can be downloaded from Section 0: Download Lecture Materials .
(green [Lecture Materials] button or cloud icon)
The lecture materials consist of approximately 250 pages, and the customer site analysis case lecture materials are excluded from the download.
Becoming an Oracle DB performance expert requires a lot of time and effort.
Perhaps this course alone will not be enough to make you an Oracle performance expert overnight, as the field is so broad.
However, if you have the right fundamentals and direction, you can become an Oracle DB expert several times faster than others.
"Oracle Performance Analysis and Instance Tuning Core Guide" will help you acquire core technologies and differentiated analysis methodologies for performance analysis. Through this, we will help you gain recognition as an indispensable expert with differentiated technical skills in your organization.
💾 Please check before taking the class.
Who is this course right for?
If you want to challenge Oracle DB tuning
Those who want to enter the Oracle DB related field
Those who want to change careers beyond their development experience
If you want to become an Oracle performance analysis expert quickly
Consultants who want a more efficient and rapid performance analysis consulting method
Need to know before starting?
Oracle DBMS Basic Knowledge
More than 3 months of Oracle DBMS operation experience and equivalent Oracle knowledge
26,387
Learners
1,323
Reviews
3,984
Answers
4.9
Rating
14
Courses
(전) 엔코아 컨설팅
(전) 한국 오라클
AI 프리랜서 컨설턴트
파이썬 머신러닝 완벽 가이드 저자
All
125 lectures ∙ (26hr 31min)
Course Materials:
All
116 reviews
4.8
116 reviews
Reviews 2
∙
Average Rating 5.0
Reviews 26
∙
Average Rating 5.0
Reviews 8
∙
Average Rating 4.0
Reviews 1
∙
Average Rating 5.0
Reviews 6
∙
Average Rating 4.7
5
Tôi nghĩ đây là một khóa học rất tốt để nghiên cứu Oracle DB từ tư duy kỹ sư. Tôi nghĩ nó dễ hiểu vì nó giải thích cấu trúc của các instance và các phần mà các sự kiện chờ đợi xảy ra tuần tự và có hệ thống, và mặc dù mất nhiều thời gian nhưng tôi vẫn kiên trì. Tuy nhiên, thỉnh thoảng có tiếng ding cảnh báo nhưng không thể tránh khỏi nên tôi đã vượt qua... haha. Vì bạn có thể tham gia các lớp học không giới hạn nên tôi nghĩ bạn sẽ tiếp tục tìm kiếm nó trong tương lai. Cảm ơn!!! :)
$59.40
Check out other courses by the instructor!
Explore other courses in the same field!
![[Bản sửa đổi] Hướng dẫn hoàn hảo về máy học PythonHình thu nhỏ khóa học](https://cdn.inflearn.com/public/courses/324238/cover/7e380aa0-48ba-4ee7-a6b2-8da7900568d6/324238-eng.png?f=avif&w=420)
![[Bản sửa đổi] Hướng dẫn hoàn chỉnh về máy tính thị giác bằng Deep LearningHình thu nhỏ khóa học](https://cdn.inflearn.com/public/courses/325035/cover/f4bbef4d-d9a9-4def-a3a5-738a9eed8245/325035-eng.jpg?f=avif&w=420)
![3. Khóa học phát triển web [Spring Framework + Framework chuẩn Chính phủ điện tử]Hình thu nhỏ khóa học](https://cdn.inflearn.com/public/courses/324888/course_cover/44f2d353-757a-4835-8935-d5b986674f91/egov-spring-eng.png?f=avif&w=420)
![[Khái niệm hay, thực hành nhiều] Phân tích dữ liệu SQL, phần giới thiệu!Hình thu nhỏ khóa học](https://cdn.inflearn.com/public/courses/328741/cover/e1d1e473-ef71-403e-93ef-63db6a7eba72/328741-eng-original.png?f=avif&w=420)
![[Loạt bài phát triển game MMORPG thực hiện bằng C# và Unity] Phần 5: Cơ sở dữ liệuHình thu nhỏ khóa học](https://cdn.inflearn.com/public/courses/325283/course_cover/afb413e6-681e-47cd-808a-099c79fed112/rookiss-rpg-5.jpg?f=avif&w=420)
