Oracle Database 19c Performance Management and Tuning
The Oracle Database 19c: Performance Management and Tuning course teaches you about the performance analysis and tuning tasks expected of a database administrator.
On successful Completion of this course you will be able to:
Basic Tuning Methods and Diagnostics
Using Statspack
Using Log and Trace Files to Monitor Performance
Using Metrics, Alerts and Baselines
Using AWR-Based Tools
Performing Oracle Database Application Monitoring
Identifying Problem SQL Statements
Influencing the Optimizer
SQL Performance Management
Tuning the Shared Pool
Tuning the Buffer Cache
Tuning the PGA
Using Automatic Memory Management
Oracle Database 19c Performance Management and Tuning eLearning