Oracle Certified Professional, Oracle Database 19c: Performance Management and Tuning (1Z0-084)

01

Module 1: Basic Tuning Methods and Diagnostics

02

Module 2: Using Statspack

03

Module 3: Using Log and Trace Files to Monitor Performance

04

Module 4: Using Metrics, Alerts and Baselines

05

Module 5: Using AWR-Based Tools

06

Module 5: Using AWR-Based Tools

07

Module 6: Performing Oracle Database Application Monitoring

08

Module 7: Identifying Problem SQL Statements

09

Module 8: Influencing the Optimizer

10

Module 9: Reducing the Cost of SQL Operations

11

Module 10: Using Real Application Testing

12

Module 11: SQL Performance Management

13

Module 12: Tuning the Shared Pool

14

Module 13: Tuning the Buffer Cache

15

Module 14: Tuning the PGA

16

Module 15: Using Automatic Memory Management

17

Module 16: Using In-Memory Features