Oracle Database 19c Performance Tuning Virtual Machine Training Appliance

Oracle Database 19c: Performance Management and Tuning Virtual Machine Training Appliance is a hands-on Lab designed to complement our Oracle Performance Management and Tuning CBT and eLearning titles; it is delivered in either Oracle Virtual Box (ova) or VMWare format.

The Performance Management and Tuning Virtual Machine Training Appliance is bundled with Oracle Database 19c VM software with our Oracle 19c Performance Management and Tuning Computer Based Training - CBT course.

Students will possess a profound knowledge of the Oracle Database architecture, great familiarity with day-to-day database administration, knowledge of which advisors can be used to inspect various aspects/areas of the Oracle Database environment, and a good working knowledge of SQL, its executions plans and generated statistics.

The Oracle Database 19c: Performance Management and Tuning course teaches you about the performance analysis and tuning tasks expected of a database administrator. 

Certification: This course will assist in preparation for the Oracle - 1Z0-084 Certification exams.

This course is designed to fully certify an individual in Oracle Database 19c Performance Management and Tuning.

1Z0-084 -- Oracle Database 19c: Performance Management and Tuning
1Z0-084 -- Oracle Database 19c: SQL Tuning Workshop

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