- Course
- Data
Oracle Database 12c Performance Tuning and Optimization
This course will teach you how to perform maintenance and manage performance in Oracle Database 12c, and overlaps heavily with the OCP exam objectives.
What you'll learn
It seems that most Oracle Database administrators enjoy twiddling and tweaking their production Oracle databases/instances to make them run as efficiently as possible. This course will teach you how to perform maintenance and manage performance. In addition, this course overlaps heavily with the OCP exam objectives.
Table of contents
- Overview | 1m 50s
- A Reference | 1m 15s
- About Oracle Performance Tuning | 3m 22s
- Oracle Database Tuning Tools | 2m 46s
- Approaches to Performance Tuning | 4m 2s
- The Automatic Workload Repository (AWR) | 1m 38s
- Enabling ADDM | 17s
- Demo 1: Enabling and Configuring ADDM | 5m
- More About DB Time | 2m 32s
- The Most Common Database Performance Problems | 1m 8s
- Methods for Generating ADDM Reports | 45s
- Demo 2: Accessing the AWR With SQL Developer | 2m 58s
- Interpreting ADDM Findings | 1m 1s
- Summary | 1m 16s
- Overview | 1m 38s
- A Resource | 59s
- ADDM Analysis and Recommendations | 2m 30s
- About Real-Time ADDM | 1m 37s
- Demo 1: Using ADDM and Real-Time ADDM | 8m 46s
- Active Session History (ASH) Analytics | 2m 7s
- Using the Advisory Framework | 1m 51s
- Demo 2: Deeper Into ASH Analytics | 5m 44s
- Demo 3: Introducing the Advisory Framework | 3m 55s
- Summary | 2m 18s
About the author
Tim Warner is a Microsoft Most Valuable Professional (MVP) and Microsoft Certified Trainer (since 1997) with nearly three decades of experience as an IT professional and technical educator.