Oracle Database 19c: Performance Management and Tuning Course

Master Oracle Database 19c tuning through real-world scenarios

40 hours of instructor-led training sessions

Gain expertise in tools like AWR, ADDM & SQL Tuning

Quality mock exams to boost Oracle 1Z0-084 prep

For intermediate-level database administrators & IT professionals

Includes lectures, discussions & exercises from certified trainers

Features hands-on implementation through live-lab sessions

Benefit from the convenience of flexible learning methods

Convenient payment options with easy instalment plans

4.9/5

6376 Enrolled

Overview

What will you learn from us:

Identify performance issues using Oracle 19c tools
Review performance with AWR and ADDM reports
Monitor databases using Statspack and SQL Developer
Improve performance via active session history analysis
Learn to automate maintenance tasks in Oracle Database 19c
Establish metrics and baselines for tuning workflows
Enhance SQL performance using SQL Tuning Advisor

Learning Outcomes

After finishing the training, you will be able to:

Learn Oracle 19c tuning with AWR, ADDM, Statspack for optimal performance

Troubleshoot issues using SQL Developer and Wait Event Statistics effectively

Monitor performance in real-time using TKPROF, SQL Trace and Emergency Monitoring tools

Improve SQL execution using SQL Plan Management and SQL Tuning Advisor

Develop skills in analysing Oracle In-Memory Column Store for enhanced performance

Manage database workloads efficiently using Automatic Workload Repository (AWR) data

Ready to get started?

Prerequisites

To enrol in the Oracle Database 19c: Performance Management and Tuning Course, it is recommended to fulfil these eligibility requirements:

A basic understanding of Oracle Database structure and its key components
Hands-on familiarity with tasks related to managing and maintaining an Oracle Database
Proficiency in SQL, including experience in writing and optimising SQL queries
Previous work experience with Oracle Databases, ideally in a DBA or database support or admin role
Awareness of core database concepts like schemas, tablespaces and data file organization
Confidence in using CLI tools such as SQL *Plus or graphical interfaces like SQL Developer

Overall ratings by our students

Upcoming sessions

Our Trainers

Learners Point has a reputation for high-quality training that makes a difference in people's lives. We undertake a practical and innovative approach to working closely with businesses to improve their workforce. Our expertise is wide-ranging with ample support from our expert trainers who are globally recognized and hold a diverse set of experiences in their field of expertise. We are proud of our instructors who take ownership of our distinctive and comprehensive training methodologies, help our students imbibe those with ease, and accomplish gracefully.

We at Learners Point believe in encouraging our students to embark upon a journey of lifelong learning and self-development, with the aid of our comprehensive and distinctive courses tailored to current market trends. The manifestation of our career-oriented approach is what we assure through a pleasant professional enriched environment with cutting-edge technology, and an outstanding while highly acknowledged training staff that uses up-to-date methodologies and quality course material. With our aim to mold professionals to be future leaders, our industry expert trainers provide the best in town mentorship to our students while endowing them with the thirst for knowledge and inspiring them to strive for professional and human excellence.

Learners Point Certificate

Earn a Course Completion Certificate, an official Learners Point credential that confirms that you have successfully completed a course with us.

Related courses

Curriculum

Defining the Scope of Performance Issues Objectives
Tuning Life Cycle Phases

Using Statistics and Wait Events to Diagnose Performance Issues
Instance Activity and Wait Event Statistics

Performance

Using Automatic Workload Repository
Managing AWR Data in a Multitenant Environment

Using ADDM to Analyze Performance
Compare Periods ADDM: Analysis

Issues

Overview
Processing a DML Statement

Maintaining Indexes
Automatic Indexing Task

Maintaining Tables
Block Space Management with Free Lists
Shrinking Segments: Overview
Advanced Index Compression

Introduction
Using Initialization Parameters to Control Optimizer Behaviour

Understanding Execution Plans
SQL*Plus AUTOTRACE

Managing Optimizer Statistics
Extended Statistics

Using Database Replay to Test System Performance
Database Replay Packages

Using Services to Monitor Applications
Creating Service
Service Aggregation Configuration

Managing Shared Pool Performance
Avoid Hard Parses
Sizing the Shared Pool

Managing Buffer Cache Performance
Buffer Cache Hit Ratio
Caching Tables
Multiple Block Sizes

Managing PGA and Temporary Space Performance
Monitoring SQL Memory Usage

Using Automatic Shared Memory Management
Using the V$SYSTEM_PARAMETER View

Frequently asked questions

The Oracle Database 19c: Performance Management and Tuning Course is a specialised training program offered by Oracle designed to help database professionals to analyse, monitor diagnose and improve the performance of Oracle 19c databases. Our course dives deep into Oracle’s architecture and internal processes. We blend theoretical concepts with hands-on labs and offering practical experience in using Oracle's tuning tools.

To enrol in the Oracle Database 19c: Performance Management and Tuning Course, it is recommended to fulfil these eligibility requirements:

1. A basic understanding of Oracle Database structure and its key components
2. Hands-on familiarity with tasks related to managing and maintaining an Oracle Database
3. Proficiency in SQL, including experience in writing and optimising SQL queries
4. Previous work experience with Oracle Databases, ideally in a DBA or database support or admin role
5. Awareness of core database concepts like schemas, tablespaces and data file organization
6. Confidence in using CLI tools such as SQL Plus or graphical interfaces like SQL Developer

In the Oracle Database 19c: Performance Management and Tuning Training, you learn a structured approach to improving database performance by mastering Oracle’s tuning tools. The core topics are:

1. Oracle Tuning Methodology
2. Database Architecture and Performance
3. Diagnostic Tools and Reports
4. SQL Tuning Techniques
5. Memory and Instance Tuning
6. I/O and Storage Tuning
7. Optimizer and Statistics
8. Concurrency and Wait Events

Earning the Oracle Database 19c: Performance Management and Tuning certification offers a wide range of benefits. These benefits are:

1. Enhanced career opportunities
2. Proven expertise in oracle performance
3. Hands-on practical skills in resolving slow queries
4. Recognition by employers in the IT industry
5. Preparation for advanced Oracle credentials

After completing the Oracle Database 19c: Performance Management and Tuning training course, you will be well-positioned to pursue specialised and high-value roles in database administration. These job roles are:

1. Oracle Database Administrator (DBA)
2. Performance Tuning Specialist
3. SQL Performance Analyst
4. Systems Architect
5. Oracle RAC Specialist
6. Database Consultant

Yes, the Oracle Database 19c: Performance Management and Tuning training course is designed to help you prepare for the Oracle Certified Professional (OCP) 1Z0-084 exam. We help you in the following ways:

1. Covers all exam objectives in the curriculum
2. Hands-on lab practice to simulate performance issues
3. Provides sessions on exam-oriented approaches
4. Includes regular mock tests and practice questions
5. Gives exam tips and strategies