Performance Tuning Methodology
Oracle 12c
| Intermediate
- 11 videos | 43m 25s
- Includes Assessment
- Earns a Badge
Broaden your knowledge of Oracle Database 12c performance tuning by examining a series of commonly occurring real-world performance problems and the typical solutions for those scenarios.
WHAT YOU WILL LEARN
-
describe the Oracle performance tuning methodology and common symptomsdescribe common errors, their diagnosis, and solutionsdescribe how to diagnose and tune CPU-related waitsdescribe how to diagnose and tune Redo-related waitsdescribe how to diagnose and tune waits related to the Redo Logdescribe how to diagnose and tune waits related to the Buffer Cache
-
describe how to diagnose and tune waits relates to Shared and Large Pooldiscuss best practices when creating and configuring tablespacesdescribe how to diagnose and tune waits related to SQL Executiondescribe the concept of direct I/O and related waitsdiscuss automated statistics gathering
IN THIS COURSE
-
1.Methodology and Common Symptoms6m 41s
-
2.Handling Errors4m 14s
-
3.CPU Waits3m 1s
-
4.Redo Waits4m 39s
-
5.Redo Log Waits3m 49s
-
6.Buffer Cache Waits3m 33s
-
7.Shared and Large Pool Waits3m 31s
-
8.Tablespace Best Practices3m 3s
-
9.SQL Execution Waits4m 19s
-
10.I/O Modes3m 48s
-
11.Statistics Gathering2m 46s
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.