Oracle Database 19c: Performance Management and Tuning Course in Bahrain

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

3531 EnrolledEnrolled Learners

4.9/5

3531 EnrolledEnrolled Learners

Overview

What you will learn:

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

Upcoming sessions

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

Meet your Trainer

Our Trainers

We take immense pride in our skilled instructors and trainers who excel in their chosen fields. Our trainers are globally recognised for their expertise and experience.Learners Point adopts a data driven research approach to learning so the experience is highly customizable and thoroughly engaging for learners from all walks of life. The sessions are classroom-based and led by an instructor. For those who seek more flexibility, we also offer high quality live and interactive sessions online.

Learning Outcomes

Successful completion of the course will help you to:

Learn Oracle 19c tuning with AWR, ADDM, Statspack for optimal performance and 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?

Learners Point Certificate

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

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 organisation
Confidence in using CLI tools such as SQL Plus or graphical interfaces like SQL Developer

Overall ratings by our students

Related courses

Learn now, pay later

Dive into your course now and pay in installments

Frequently asked questions

Our Oracle Database 19c: Performance Management and Tuning Course is designed for database professionals. We train them to analyse, monitor, diagnose and improve the performance of Oracle 19c databases. Our curriculum focuses on Oracle’s architecture and internal processes, and learners get hands-on with Oracle's tuning tools.

To enrol in our Oracle Database 19c: Performance Management and Tuning Course, you must fulfil these eligibility criteria:

Basic understanding of Oracle Database structure and its key components
Familiarity in managing and maintaining an Oracle Database
Fluent knowledge 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 organisation
Confidence in using CLI tools such as SQL Plus or graphical interfaces like SQL Developer

After completing this course, you can avail exciting job roles in database administration. Here are the top 5 job roles available in Bahrain:

Oracle Database Administrator (DBA)
Performance Tuning Specialist
SQL Performance Analyst
Database Reliability Engineer
Oracle Functional Consultant

In this training, students master essential Oracle tools to improve database performance. These topics are:

Oracle Tuning Methodology
SQL Tuning Techniques
Diagnostic Tools and Reports
Concurrency and Wait Events
Memory and Instance Tuning
I/O and Storage Tuning
Optimiser and Statistics
Database Architecture and Performance

In Bahrain, the demand for certified Database administrators is growing due to its cloud-first policy as part of digital transformation. Completing this Oracle Database 19c: Performance Management and Tuning course offers you several benefits that are listed below: