Danh mục
Duocmmo Tedu Tin học văn phòng Laravel Cyberlearn Khoá học miễn phí Tất cả khoá học
Get link khoá học
Trang chủ
Development
Database Design & Development
Oracle Database
Oracle Database Performance Tuning

Oracle Database Performance Tuning

Loại khoá học: Database Design & Development

Do you want to be an Oracle Database Performance Tuning Professional? If yes, do not miss this opportunity!

image
50.000 VND
75 VND
Đầy Đủ Bài Giảng
Học Online Tiện Lợi
Kích Hoạt Nhanh 2-5 Phút
Thanh toán tự động
Được phép tải xuống

Tổng quan

Nội dung khoá học

Đánh giá

Mô tả

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!

Bạn sẽ học được gì

Oracle database performance tuning

Yêu cầu

  • Oracle SQL language, basic level
  • Oracle database architecture, accomplished level
  • Linux operating system, basic level
  • PC with Windows operating system, RAM: 8 GB

Nội dung khoá học

37 sections

Introduction

1 lectures
Introducing the Course
05:08

Practice 1 - Preparing Practice Environment

7 lectures
Practice 1 - Preparing Practice Environment 2 of 7
09:52
Practice 1 - Preparing Practice Environment 1 of 7
03:55
Practice 1 - Preparing Practice Environment 3 of 7
08:29
Practice 1 - Preparing Practice Environment 4 of 7
07:56
Practice 1 - Preparing Practice Environment 5 of 7
04:12
Practice 1 - Preparing Practice Environment 6 of 7
06:33
Practice 1 - Preparing Practice Environment 7 of 7
04:01

Introduction to Oracle Database Performance Tuning

3 lectures
Introduction to Oracle Database Performance Tuning 1 of 3
05:45
Introduction to Oracle Database Performance Tuning 2 of 3
06:55
Introduction to Oracle Database Performance Tuning 3 of 3
02:00

About Performance Tuning in IT Systems

2 lectures
About Performance Tuning in IT Systems 1 of 2
08:35
About Performance Tuning in IT Systems 2 of 2
02:43

Introduction to Oracle Database Performance Tuning Tools

1 lectures
Introduction to Oracle Database Performance Tuning Tools
10:55

Using Time Model

5 lectures
Using Time Model 1 of 3
04:43
Using Time Model 2 of 3
04:54
Using Time Model 3 of 3
08:38
Practice 2 -Using Time Model 1 of 2
06:59
Practice 2 -Using Time Model 2 of 2
07:50

Using Instance Activity Statistics

2 lectures
Using Instance Activity Statistics 1 of 2
04:53
Using Instance Activity Statistics 2 of 2
04:18

Wait Events

6 lectures
Wait Events 1 of 3
07:37
Wait Events 2 of 3
07:51
Wait Events 3 of 3
11:02
Practice 3 - Viewing Instance Activity and Wait Events 1 of 3
06:35
Practice 3 - Viewing Instance Activity and Wait Events 2 of 3
05:15
Practice 3 - Viewing Instance Activity and Wait Events 3 of 3
10:18

Using AWR

27 lectures
Overview to Automatic Workload Repository (AWR)
09:07
Managing AWR Snapshots 1 of 3
04:15
Managing AWR Snapshots 2 of 3
07:34
Managing AWR Snapshots 3 of 3
06:50
Practice 4 - Managing Automatic Workload Repository (AWR) 1 of 2
04:15
Practice 4 - Managing Automatic Workload Repository (AWR) 2 of 2
06:15
Using AWR Reports 1 of 9
06:41
Using AWR Reports 2 of 9
05:23
Using AWR Reports 3 of 9
09:21
Using AWR Reports 4 of 9
06:57
Using AWR Reports 5 of 9
05:25
Using AWR Reports 6 of 9
06:27
Using AWR Reports 7 of 9
03:33
Using AWR Reports 8 of 9
04:43
Using AWR Reports 9 of 9
04:49
Using AWR Comparison Reports
05:22
Practice 5 - Using AWR Reports 1 of 6
05:55
Practice 5 - Using AWR Reports 2 of 6
03:27
Practice 5 - Using AWR Reports 3 of 6
06:47
Practice 5 - Using AWR Reports 4 of 6
05:37
Practice 5 - Using AWR Reports 5 of 6
05:25
Practice 5 - Using AWR Reports 6 of 6
03:33
Practice 6 - Using AWR SQL Reports
07:08
Managing AWR Baselines
10:19
Managing AWR Baseline Templates 1 of 2
07:01
Managing AWR Baseline Templates 2 of 2
03:24
Practice 7 - Using AWR Baselines and Baseline Templates
06:46

Metrics, Event Histograms and Server-generated Alerts

7 lectures
Metrics and Event Histograms 1 of 2
07:11
Metrics and Event Histograms 2 of 2
06:41
Server-generated Alerts 1 of 2
08:58
Server-generated Alerts 2 of 2
07:04
Practice 8 - Using Server-generated Alerts 1 of 2
07:03
Practice 8 - Using Server-generated Alerts 2 of 2
06:44
Adaptive Thresholds
06:32

Using Statspack

6 lectures
Using Statspack 1 of 4
05:49
Using Statspack 2 of 4
05:35
Using Statspack 3 of 4
06:46
Using Statspack 4 of 4
05:01
Practice 9 - Using Statspack 1 of 2
05:05
Practice 9 - Using Statspack 2 of 2
07:53

Using Automatic Database Diagnostic Monitor (ADDM)

7 lectures
Using Automatic Database Diagnostic Monitor (ADDM) 1 of 3
05:27
Using Automatic Database Diagnostic Monitor (ADDM) 2 of 3
06:31
Using Automatic Database Diagnostic Monitor (ADDM) 3 of 3
03:14
Using ADDM Comparison Report 1 of 2
06:36
Using ADDM Comparison Report 2 of 2
03:33
Practice 10 - Using Automatic Database Diagnostic Monitor (ADDM) 1 of 2
07:15
Practice 10 - Using Automatic Database Diagnostic Monitor (ADDM) 2 of 2
12:05

Using Active Session History (ASH)

15 lectures
Using Active Session History (ASH) 1 of 3
11:06
Using Active Session History (ASH) 2 of 3
06:38
Using Active Session History (ASH) 3 of 3
03:39
Querying ASH 1 of 4
06:57
Querying ASH 2 of 4
05:40
Querying ASH 3 of 4
04:33
Querying ASH 4 of 4
04:35
Practice 11 - Using Active Session History (ASH) 1 of 4
06:54
Practice 11 - Using Active Session History (ASH) 2 of 4
06:42
Practice 11 - Using Active Session History (ASH) 3 of 4
05:31
Practice 11 - Using Active Session History (ASH) 4 of 4
03:00
Practice 12 - Linking ASH to Its Dimension Views 1 of 4
05:49
Practice 12 - Linking ASH to Its Dimension Views 2 of 4
06:58
Practice 12 - Linking ASH to Its Dimension Views 3 of 4
05:37
Practice 12 - Linking ASH to Its Dimension Views 4 of 4
04:21

Using Database Services

13 lectures
Introducing Database Services 1 of 4
06:02
Introducing Database Services 2 of 4
05:53
Introducing Database Services 3 of 4
04:09
Introducing Database Services 4 of 4
04:41
Practice 13 - Using Database Service Performance Statistics 1 of 2
06:52
Practice 13 - Using Database Service Performance Statistics 2 of 2
06:35
Using Module Action and Client Identifier 1 of 3
04:13
Using Module Action and Client Identifier 2 of 3
06:29
Using Module Action and Client Identifier 3 of 3
04:53
Practice 14 - Using Module, Action, and Client Identifier Attributes 1 of 4
05:15
Practice 14 - Using Module, Action, and Client Identifier Attributes 2 of 4
07:07
Practice 14 - Using Module, Action, and Client Identifier Attributes 3 of 4
05:48
Practice 14 - Using Module, Action, and Client Identifier Attributes 4 of 4
05:09

SQL Tracing

9 lectures
SQL Tracing 1 of 3
04:36
SQL Tracing 2 of 3
06:16
SQL Tracing 3 of 3
06:37
Using tkprof Utility 1 of 2
06:59
Using tkprof Utility 2 of 2
07:23
Practice 15 - Tracing SQL Statements using DBMS_MONITOR 1 of 4
05:33
Practice 15 - Tracing SQL Statements using DBMS_MONITOR 2 of 4
04:44
Practice 15 - Tracing SQL Statements using DBMS_MONITOR 3 of 4
04:01
Practice 15 - Tracing SQL Statements using DBMS_MONITOR 4 of 4
04:06

Monitoring Database Operations in Real-time

6 lectures
Monitoring Database Operations in Real-time 1 of 3
06:12
Monitoring Database Operations in Real-time 2 of 3
08:05
Monitoring Database Operations in Real-time 3 of 3
04:23
Practice 16 - Monitoring Database Operations in Real-time 1 of 3
04:34
Practice 16 - Monitoring Database Operations in Real-time 2 of 3
06:29
Practice 16 - Monitoring Database Operations in Real-time 3 of 3
06:00

Managing the Automated Maintenance Tasks

3 lectures
Managing the Automated Maintenance Tasks 1 of 2
05:13
Managing the Automated Maintenance Tasks 2 of 2
03:24
Practice 17 - Managing Automated Maintenance Tasks
05:55

Overview of the Tools Covered So Far

1 lectures
Overview of the Tools Covered So Far
07:41

Handling Enqueue Waits

6 lectures
Handling Enqueue Waits 1 of 3
05:44
Handling Enqueue Waits 2 of 3
06:22
Handling Enqueue Waits 3 of 3
07:50
Practice 18 - Handling Enqueue Waits 1 of 3
06:32
Practice 18 - Handling Enqueue Waits 2 of 3
06:59
Practice 18 - Handling Enqueue Waits 3 of 3
04:17

Handling Latches and Mutexes

12 lectures
Introducing Latches and Mutex 1 of 2
10:16
Introducing Latches and Mutex 2 of 2
04:25
Handling Latch and Mutex Contention 1 of 2
06:42
Handling Latch and Mutex Contention 2 of 2
07:00
Handling Cache Buffer Chain (CBC) Latch 1 of 2
06:32
Handling Cache Buffer Chain (CBC) Latch 2 of 2
06:20
Handling Other Latch Types 1 of 2
05:08
Handling Other Latch Types 2 of 2
04:00
Practice 19 - Handling Latch and Mutex Contention 1 of 4
05:04
Practice 19 - Handling Latch and Mutex Contention 2 of 4
06:19
Practice 19 - Handling Latch and Mutex Contention 3 of 4
06:41
Practice 19 - Handling Latch and Mutex Contention 4 of 4
05:28

Tuning the Shared Pool

15 lectures
Tuning the Shared Pool 1 of 4
05:05
Tuning the Shared Pool 2 of 4
05:59
Tuning the Shared Pool 3 of 4
05:30
Tuning the Shared Pool 4 of 4
04:00
Sizing the Shared Pool
08:48
Practice 20 - Tuning the Shared Pool 1 of 2
10:53
Practice 20 - Tuning the Shared Pool 2 of 2
12:05
Caching Session Cursors 1 of 2
05:40
Caching Session Cursors 2 of 2
04:47
Practice 21 - Caching Session Cursors 1 of 2
06:45
Practice 21 - Caching Session Cursors 2 of 2
06:41
Managing Server Result Cache 1 of 2
06:14
Managing Server Result Cache 2 of 2
05:52
Practice 22 - Managing Server Result Cache 1 of 2
06:29
Practice 22 - Managing Server Result Cache 2 of 2
06:46

Tuning the Buffer Cache

13 lectures
Tuning the Buffer Cache 1 of 5
06:27
Tuning the Buffer Cache 2 of 5
09:02
Tuning the Buffer Cache 3 of 5
06:49
Tuning the Buffer Cache 4 of 5
04:21
Tuning the Buffer Cache 5 of 5
05:07
Practice 23 - Tuning the Buffer Cache 1 of 3
13:09
Practice 23 - Tuning the Buffer Cache 2 of 3
05:09
Practice 23 - Tuning the Buffer Cache 3 of 3
07:04
Using Smart Flash Cache 1 of 3
05:57
Using Smart Flash Cache 2 of 3
05:13
Using Smart Flash Cache 3 of 3
05:49
Practice 24 - Using Smart Flash Cache 1 of 2
13:00
Practice 24 - Using Smart Flash Cache 2 of 2
06:15

Tuning the PGA

9 lectures
Tuning the PGA 1 of 6
06:58
Tuning the PGA 2 of 6
06:42
Tuning the PGA 3 of 6
05:54
Tuning the PGA 4 of 6
05:23
Tuning the PGA 5 of 6
05:27
Tuning the PGA 6 of 6
04:27
Practice 25 - Tuning the PGA 1 of 3
10:16
Practice 25 - Tuning the PGA 2 of 3
04:58
Practice 25 - Tuning the PGA 3 of 3
04:05

Tuning the Redo Path

5 lectures
Tuning the Redo Path 1 of 4
07:33
Tuning the Redo Path 2 of 4
04:05
Tuning the Redo Path 3 of 4
05:19
Tuning the Redo Path 4 of 4
09:55
Practice 26 - Tuning the Redo Path
11:21

Detecting CPU Bottlenecks

4 lectures
Detecting CPU Bottlenecks 1 of 2
05:14
Detecting CPU Bottlenecks 2 of 2
09:49
Practice 27 - Detecting CPU Bottlenecks 1 of 2
07:11
Practice 27 - Detecting CPU Bottlenecks 2 of 2
05:29

Tuning Disk IO Operations in Oracle Database

10 lectures
Tuning Disk IO Operations in Oracle Database 1 of 8
04:50
Tuning Disk IO Operations in Oracle Database 2 of 8
06:05
Tuning Disk IO Operations in Oracle Database 3 of 8
06:55
Tuning Disk IO Operations in Oracle Database 4 of 8
04:08
Tuning Disk IO Operations in Oracle Database 5 of 8
05:32
Tuning Disk IO Operations in Oracle Database 6 of 8
06:27
Tuning Disk IO Operations in Oracle Database 7 of 8
04:10
Tuning Disk IO Operations in Oracle Database 8 of 8
03:44
Practice 28 - Tuning Disk IO Operations in Oracle Database 1 of 2
07:46
Practice 28 - Tuning Disk IO Operations in Oracle Database 2 of 2
04:02

Maintaining In-production Indexes for Performance

7 lectures
Maintaining In-production Indexes for Performance 1 of 5
07:39
Maintaining In-production Indexes for Performance 2 of 5
09:12
Maintaining In-production Indexes for Performance 3 of 5
04:23
Maintaining In-production Indexes for Performance 4 of 5
04:24
Maintaining In-production Indexes for Performance 5 of 5
06:13
Practice 29 - Performing Index Defragmentation 1 of 2
08:17
Practice 29 - Performing Index Defragmentation 2 of 2
03:30

Handling Row Migration and Row Chaining

8 lectures
Introducing Row Migration and Row Chaining 1 of 2
05:49
Introducing Row Migration and Row Chaining 2 of 2
03:49
Handling Row Migration and Row Chaining 1 of 3
06:22
Handling Row Migration and Row Chaining 2 of 3
07:09
Handling Row Migration and Row Chaining 3 of 3
05:25
Practice 30 - Handling Row Migration and Row Chaining 1 of 3
05:21
Practice 30 - Handling Row Migration and Row Chaining 2 of 3
05:29
Practice 30 - Handling Row Migration and Row Chaining 3 of 3
06:45

Diagnosing Table Fragmentation

3 lectures
Diagnosing Table Fragmentation 1 of 2
06:20
Diagnosing Table Fragmentation 2 of 2
05:12
Practice 31 - Diagnosing Table Fragmentation
07:45

Using Table Compression

5 lectures
Using Table Compression 1 of 3
07:28
Using Table Compression 2 of 3
04:44
Using Table Compression 3 of 3
04:05
Practice 32 - Using Table Compression 1 of 2
08:05
Practice 32 - Using Table Compression 2 of 2
04:48

Introducing In-Memory Column Store

4 lectures
Introducing In-Memory Column Store 1 of 3
06:54
Introducing In-Memory Column Store 2 of 3
04:42
Introducing In-Memory Column Store 3 of 3
04:45
Practice 33 - Introducing In-Memory Column Store
07:49

Optimizing Database Connection

7 lectures
Optimizing Database Connection 1 of 6
06:06
Optimizing Database Connection 2 of 6
05:26
Optimizing Database Connection 3 of 6
06:33
Optimizing Database Connection 4 of 6
05:19
Optimizing Database Connection 5 of 6
05:03
Optimizing Database Connection 6 of 6
05:46
Practice 34 - Optimizing Database Connection
15:10

Monitoring Oracle Database Performance using EM Database Express

6 lectures
Monitoring Oracle Database Performance using EM Database Express
09:46
Using Oracle EM Express for Performance Tuning - Demo 1 of 5
10:22
Using Oracle EM Express for Performance Tuning - Demo 2 of 5
05:42
Using Oracle EM Express for Performance Tuning - Demo 3 of 5
04:40
Using Oracle EM Express for Performance Tuning - Demo 4 of 5
13:54
Using Oracle EM Express for Performance Tuning - Demo 5 of 5
06:23

Monitoring OS Performance using Linux Utilities

12 lectures
Monitoring OS Performance using Linux Utilities 1 of 2
04:22
Monitoring OS Performance using Linux Utilities 2 of 2
03:04
Practice 35 - Monitoring OS Performance using Linux Utilities 1 of 5
09:42
Practice 35 - Monitoring OS Performance using Linux Utilities 2 of 5
11:44
Practice 35 - Monitoring OS Performance using Linux Utilities 3 of 5
06:48
Practice 35 - Monitoring OS Performance using Linux Utilities 4 of 5
06:12
Practice 35 - Monitoring OS Performance using Linux Utilities 5 of 5
09:07
Using OSWatcher Black Box 1 of 3
05:41
Using OSWatcher Black Box 2 of 3
06:27
Using OSWatcher Black Box 3 of 3
09:02
Practice 36 - Using OSWatcher Black Box 1 of 2
05:43
Practice 36 - Using OSWatcher Black Box 2 of 2
07:08

Using SQL Performance Analyzer

5 lectures
Using SQL Performance Analyzer 1 of 3
03:36
Using SQL Performance Analyzer 2 of 3
05:32
Using SQL Performance Analyzer 3 of 3
05:37
Practice 37 - Using SQL Performance Analyzer 1 of 2
05:11
Practice 37 - Using SQL Performance Analyzer 2 of 2
05:55

Using Database Replay

11 lectures
Using Database Replay 1 of 4
07:31
Using Database Replay 2 of 4
09:04
Using Database Replay 3 of 4
09:44
Using Database Replay 4 of 4
02:52
Practice 38 - Using Database Replay 1 of 7
04:02
Practice 38 - Using Database Replay 2 of 7
05:20
Practice 38 - Using Database Replay 3 of 7
03:49
Practice 38 - Using Database Replay 4 of 7
02:41
Practice 38 - Using Database Replay 5 of 7
03:17
Practice 38 - Using Database Replay 6 of 7
03:05
Practice 38 - Using Database Replay 7 of 7
03:33

Course Documents

1 lectures
Course Documents and Files
00:02

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

Khoá học liên quan

Self Driving and ROS - Learn by Doing! Odometry & Control

Self Driving and ROS - Learn by Doing! Odometry & Control

1.599.000 VND
50.000 VND
Practice Exams | AWS Certified Solutions Architect Associate

Practice Exams | AWS Certified Solutions Architect Associate

125 VND
50.000 VND
Ethical Hacking Course by Black Hat Pakistan

Ethical Hacking Course by Black Hat Pakistan

26 VND
50.000 VND
AWS Cloud for beginner (Vietnamese)

AWS Cloud for beginner (Vietnamese)

90 VND
50.000 VND
OpenStack Essentials

OpenStack Essentials

1.499.000 VND
50.000 VND
Java Certification : OCA (1Z0-808) Exam Simulation [2023]

Java Certification : OCA (1Z0-808) Exam Simulation [2023]

1.399.000 VND
50.000 VND
Master Big Data - Apache Spark/Hadoop/Sqoop/Hive/Flume/Mongo

Master Big Data - Apache Spark/Hadoop/Sqoop/Hive/Flume/Mongo

1.049.000 VND
50.000 VND
Reverse Engineering and Malware Analysis Fundamentals

Reverse Engineering and Malware Analysis Fundamentals

1.399.000 VND
50.000 VND
Microsoft Windows Server 2016 Training for Beginners

Microsoft Windows Server 2016 Training for Beginners

1.799.000 VND
50.000 VND
Learn Autocad API with C# - MVVM - WPF

Learn Autocad API with C# - MVVM - WPF

25 VND
50.000 VND
Ultimate AWS Certified Solutions Architect Associate SAA-C03

Ultimate AWS Certified Solutions Architect Associate SAA-C03

185 VND
50.000 VND
Website Hacking / Penetration Testing

Website Hacking / Penetration Testing

95 VND
50.000 VND
10 Sample Exams ISTQB Foundation Level (CTFL) v4.0 [NEW!]

10 Sample Exams ISTQB Foundation Level (CTFL) v4.0 [NEW!]

26 VND
50.000 VND
MongoDB : A Complete Database Administration Course

MongoDB : A Complete Database Administration Course

999.000 VND
50.000 VND
Become Zabbix Administrator For Expert

Become Zabbix Administrator For Expert

799.000 VND
50.000 VND
Learn 5 PLCs in a Day-AB, Siemens, Schneider, Omron & Delta

Learn 5 PLCs in a Day-AB, Siemens, Schneider, Omron & Delta

90 VND
50.000 VND
image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.

Get khoá học cho tôi