Autoplay
Autocomplete
Previous Lecture
Complete and Continue
Oracle Database 19c: Performance Management and Tuning
Downloadable Resources
Course Slides
Lab Guide
Lab Setup
Lab Setup - Part1 (102:31)
Lab Setup - Part2 (92:33)
Introduction
Introduction (67:22)
Defining the Scope of Performance Issues
Defining the Scope of Performance Issues (49:33)
Basic Tuning Diagnostics
Overview of Statistics, Instance Activity and Time Model Statistics (96:22)
Wait Event Statistics and Lab Practices (92:45)
Using Automatic Workload Repository (AWR)
AWR Concepts and Administration (89:40)
Generate and Analyze AWR Reports - Part1 (92:42)
Generate and Analyze AWR Reports - Part2 (80:22)
AWR Compare Periods Reports, AWR SQL Report (71:34)
Using Baselines
Baselines and Baseline Templates (64:42)
Using AWR-based Tools
Automated Maintenance Tasks (27:35)
ADDM (87:37)
ASH (125:57)
Using Metrics and Alerts
Metrics, Histograms, Alerts (77:25)
Using Statspack
Using Statspack (64:52)
Real-time Database Operation Monitoring
Monitoring Database Operation in Real-Time (65:55)
Monitoring Applications
Monitoring Applications using Services, Modules, Actions (126:27)
Tuning the Shared Pool
Tuning Shared Pool - Part1 (80:23)
Tuning Shared Pool - Part2 (103:23)
DOWNLOAD - Lab Practice for Server Result Cache Lesson
Tuning the Buffer Cache
Tuning the Buffer Cache - Concepts (98:35)
Tuning the Buffer Cache - Lab Practices (89:31)
Tuning the Redo Log
Tuning Redo Log (66:29)
Tuning PGA and Temporary Space
Concepts - Tuning PGA and Temporary Tablespace (83:51)
Lab Practices - Tuning PGA and Temporary Tablespace (53:31)
Using Automatic Memory Management
Oracle Database Memory Management (57:12)
Reducing the Cost of SQL Operations
Concepts - Reducing the cost of SQL Operations (112:42)
Lab Practices (44:46)
Using SQL Performance Analyzer
Concepts - Real Application Testing, SQL Performance Analyzer, Database Replay (33:36)
Lab - Using SQL Performance Analyzer (45:21)
Using Database Replay
Lab - Using DB Replay (72:47)
Using Statspack
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock