Oracle Database 19c: Performance Management and Tuning Course in Oman
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.87/54646 EnrolledEnrolled Learners
4.87/54646 EnrolledEnrolled Learners
Overview
What we are going to teach you:
- Detect performance bottlenecks using Oracle 19c diagnostic tools
- Analyze system efficiency through AWR and ADDM reports
- Monitor database activity with Statspack and SQL Developer
- Optimize performance by evaluating Active Session History (ASH)
- Automate routine maintenance tasks in Oracle Database 19c
- Set benchmarks and performance metrics to streamline tuning processes
- Boost SQL efficiency using the SQL Tuning Advisor
Upcoming sessions
Curriculum
1
Defining the Scope of Performance Issues Objectives
2
Tuning Life Cycle Phases
1
Using Statistics and Wait Events to Diagnose Performance Issues
2
Instance Activity and Wait Event Statistics
1
Performance
1
Using Automatic Workload Repository
2
Managing AWR Data in a Multitenant Environment
1
Using ADDM to Analyze Performance
2
Compare Periods ADDM: Analysis
1
Issues
1
Overview
2
Processing a DML Statement
1
Maintaining Indexes
2
Automatic Indexing Task
1
Maintaining Tables
2
Block Space Management with Free Lists
3
Shrinking Segments: Overview
4
Advanced Index Compression
1
Introduction
2
Using Initialization Parameters to Control Optimizer Behaviour
1
Understanding Execution Plans
2
SQL*Plus AUTOTRACE
1
Managing Optimizer Statistics
2
Extended Statistics
1
Using Database Replay to Test System Performance
2
Database Replay Packages
1
Using Services to Monitor Applications
2
Creating Service
3
Service Aggregation Configuration
1
Managing Shared Pool Performance
2
Avoid Hard Parses
3
Sizing the Shared Pool
1
Managing Buffer Cache Performance
2
Buffer Cache Hit Ratio
3
Caching Tables
4
Multiple Block Sizes
1
Managing PGA and Temporary Space Performance
2
Monitoring SQL Memory Usage
1
Using Automatic Shared Memory Management
2
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
After finishing the training, you will be able to:
1
Master Oracle 19c performance tuning with tools like AWR, ADDM, and Statspack
2
Diagnose and resolve performance issues using SQL Developer and Wait Event metrics
3
Track real-time performance with TKPROF, SQL Trace, and advanced monitoring utilities
4
Enhance SQL execution through SQL Plan Management and the SQL Tuning Advisor
5
Build expertise in analyzing Oracle In-Memory Column Store for performance gains
6
Optimize workload management by using insights from AWR data
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 organization
- Confidence in using CLI tools such as SQL *Plus or graphical interfaces like SQL Developer
Overall ratings by our students
Related courses
Frequently asked questions
Our Oracle Database 19c: Performance Management and Tuning Course in Oman offers practical training to help you analyse, tune, and improve database performance. Delivered by certified Oracle professionals, we focus on real-world skills like SQL tuning, memory optimisation, and performance troubleshooting. You gain valuable hands-on experience with tools widely used in enterprise environments for monitoring and managing Oracle databases effectively.
This course is ideal for Oracle DBAs, developers, IT professionals, data analysts, and consultants. It suits anyone responsible for maintaining, tuning, or monitoring Oracle 19c databases. The training supports career growth for those looking to strengthen their performance tuning and optimisation skills in real-world environments.
Participants learn to use tools like AWR, ADDM, ASH, SQL Tuning Advisor, SQL Access Advisor, SQL Trace, and TKPROF. Our course covers techniques such as SQL tuning, memory and instance tuning, bottleneck identification, event analysis, and performance optimisation in RAC and network setups. These tools help you resolve issues and keep databases running smoothly.
Completing this course boosts your job prospects and career path in Oman. As Oracle 19c adoption grows, companies need skilled professionals to ensure top performance. This training prepares you for senior roles like Performance Engineer or Database Architect. With strong tuning skills, you become a valuable asset and earn higher salaries in the IT field.
Our Oracle Database 19c: Performance Management and Tuning Course in Oman teaches you how to identify and resolve performance issues using Oracle tools. You work with AWR, SQL tuning, trace files, and event analysis to detect bottlenecks like slow queries or memory problems. These troubleshooting skills help you maintain stable, efficient Oracle 19c environments, making you more capable of handling real-time database challenges.
Do you want to learn more about Learners Point Academy?
- Learn more about courses
- Understand about our methodology
- Let’s talk about Corporate trainings
- Anything else that you want to know, we are here for you!
