Oracle Database 19c: Performance Management and Tuning Training

Last Updated: 04 07 2025

In the Oracle Database 19c: Performance Management and Tuning Course, learners gain important insight into identifying and enhancing the performance of Oracle databases. This course is specifically for database administrators, analysts, and performance professionals and takes a step-by-step approach to performance tuning with Oracle 19c using methodologies and tools that have been successfully used by other businesses.  

Learners will understand how to monitor and troubleshoot performance using the key Oracle Database 19c performance management and tuning products, including AWR (Automatic Workload Repository), ASH (Active Session History), and ADDM (Automatic Database Diagnostic Monitor), as well as managing optimizer statistics, improving SQL performance, and tuning memory and space consumption as it relates to database operation efficiency.  

Participants will also be able to apply the knowledge learned through hands-on labs based on live real-world situations or scenarios and utilise performance management tools, including those in Oracle Enterprise Manager Cloud Control and SQL Developer, as well as leverage features to maintain performance, such as the In-Memory Column Store.  

Ideal for those who are either new to performance tuning or refreshing their skills in performance tuning, this training will provide knowledge that is applied instantly and with real-world instruction.  

Offered by the Best Corporate Training Company, this course is a premier offering of the Best Training Company for professionals wanting to deliver the best in database performance with Oracle Database 19c. 

bannerImg

Learning Options for You

  • Live Training (Duration : 32 Hours)
  • Per Participant

Fee: On Request

Course Prerequisites

and a good understanding of its architecture. Prior knowledge of SQL and basic tuning concepts is recommended. 

  • Familiarity with Oracle Database 12c/19c administration 
  • Working knowledge of SQL and PL/SQL 
  • Understanding of database architecture and components 
  • Basic experience using Oracle Enterprise Manager and command-line tools 

Learning Objectives

By the end of this course, participants will be able to tune Oracle Database 19c effectively using recommended tools and techniques. Key skills and topics include: 

  • Understand Oracle’s performance tuning methodology and best practices 
  • Identify common causes of performance problems 
  • Use AWR, ASH, and ADDM reports to analyze performance 
  • Tune SQL statements using SQL Tuning Advisor and SQL Plan Management 
  • Optimize memory, I/O, and database configuration for performance 
  • Monitor and resolve concurrency and locking issues 
  • Implement proactive performance monitoring and maintenance 

Target Audience

This course is ideal for IT professionals responsible for ensuring optimal performance of Oracle databases in production environments. Suitable roles include: 

  • Database Administrators (DBAs) 
  • Database Developers and Engineers 
  • Performance Tuning Specialists 
  • Support Engineers working on performance-related issues 
  • Technical Consultants managing Oracle database deployments  

*Excluding VAT and GST

Register Your Interest

captcha
Students Reviews

Students Say About Our Courses

underline
testimonialImg