What you'll learn

Skills you'll gain

There are 12 modules in this course

Your journey begins with an introduction to performance tuning fundamentals and setting up a practice environment, providing a strong foundation for hands-on learning. Explore time models, instance activity statistics, and the significance of wait events to diagnose and resolve performance bottlenecks effectively. Dive deeper into advanced topics like Automatic Workload Repository (AWR), Adaptive Thresholds, and Statspack reports, gaining practical insights into optimizing database performance. The course also covers key diagnostic tools, including the Automatic Database Diagnostic Monitor (ADDM) and server-generated alerts. Engage in real-world scenarios to develop a robust skill set for monitoring, analyzing, and tuning Oracle databases. With in-depth hands-on exercises, you will solidify your understanding of best practices and advanced techniques to handle complex performance challenges. This course is ideal for database administrators, IT professionals, and anyone seeking to enhance their Oracle database management skills. Basic knowledge of Oracle databases is recommended, making this course suitable for beginner to intermediate learners eager to elevate their expertise.

Practice 1 - Preparing Practice Environment

Introduction to Oracle Database Performance Tuning

About Performance Tuning in IT Systems

Introduction to Oracle Database Performance Tuning Tools

Using Time Model

Using Instance Activity Statistics

Wait Events

Using AWR

Metrics, Event Histograms, and Server-Generated Alerts

Using Statspack

Using Automatic Database Diagnostic Monitor (ADDM)

Explore more from Data Management