Introduction to Performance Tuning
Oracle 12c
| Intermediate
- 15 videos | 29m 11s
- Includes Assessment
- Earns a Badge
There are many methodologies for troubleshooting performance problems in Oracle Database 12c. Learn about performance management techniques, including tuning goals and objectives, and working with waits, events, classes, and statistics.
WHAT YOU WILL LEARN
-
Define the components of performance management
Identify who is responsible for performance management of the oracle database
Describe the oracle tuning methodology
Describe effective tuning goals
List the steps of a general tuning session
Identify tuning objectives
List the top timed events
Define the concept of db time -
Describe cpu and wait time tuning dimensions
Define the time model
Work with the dynamic performance views
Describe database wait events
Describe database wait classes
Use sql to display wait event statistics
Describe commonly observed wait events
IN THIS COURSE
-
1. Introduction to Performance Management2m 22sIn this video, you will learn how to define the components of performance management. FREE ACCESS
-
2. Who Does Performance Management1m 50sFind out how to identify who is responsible for performance management of the Oracle database. FREE ACCESS
-
3. Tuning Methodology1m 48sUpon completion of this video, you will be able to describe the oracle tuning methodology. FREE ACCESS
-
4. Effective Tuning Goals2m 14sAfter watching this video, you will be able to describe effective tuning goals. FREE ACCESS
-
5. General Tuning Session1m 10sAfter completing this video, you will be able to list the steps of a general tuning session. FREE ACCESS
-
6. Tuning Objectives2m 13sDuring this video, you will learn how to identify tuning objectives. FREE ACCESS
-
7. Top Timed Events1m 53sUpon completion of this video, you will be able to list the top timed events. FREE ACCESS
-
8. DB Time1m 42sFind out how to define the concept of database time. FREE ACCESS
-
9. CPU and Wait Time Tuning Dimensions1m 36sAfter completing this video, you will be able to describe CPU and wait time tuning dimensions. FREE ACCESS
-
10. Time Model Overview2m 13sIn this video, find out how to define the time model. FREE ACCESS
-
11. Dynamic Performance Views2m 41sIn this video, you will learn how to work with the dynamic performance views. FREE ACCESS
-
12. Wait Events1m 58sUpon completion of this video, you will be able to describe database wait events. FREE ACCESS
-
13. Wait Classes1m 55sAfter completing this video, you will be able to describe the database wait classes. FREE ACCESS
-
14. Wait Event Statistics1m 38sIn this video, find out how to use SQL to display statistics for wait events. FREE ACCESS
-
15. Commonly Observed Wait Events1m 59sUpon completion of this video, you will be able to describe commonly observed wait events. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
