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 symptoms
describe common errors, their diagnosis, and solutions
describe how to diagnose and tune CPU-related waits
describe how to diagnose and tune Redo-related waits
describe how to diagnose and tune waits related to the Redo Log
describe how to diagnose and tune waits related to the Buffer Cache -
describe how to diagnose and tune waits relates to Shared and Large Pool
discuss best practices when creating and configuring tablespaces
describe how to diagnose and tune waits related to SQL Execution
describe the concept of direct I/O and related waits
discuss 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.
