Oracle Database 19c: Performance Management and Tuning Course in Saudi Arabia
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.8/55046 EnrolledEnrolled Learners
4.8/55046 EnrolledEnrolled Learners
Overview
What our training includes:
- 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
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
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.
Learning Outcomes
Upon course completion, you will:
1
Learn Oracle 19c tuning with AWR, ADDM, Statspack for optimal performance
2
Troubleshoot issues using SQL Developer and Wait Event Statistics effectively
3
Monitor performance in real-time using TKPROF, SQL Trace and Emergency Monitoring tools
4
Improve SQL execution using SQL Plan Management and SQL Tuning Advisor
5
Develop skills in analysing Oracle In-Memory Column Store for enhanced performance
6
Manage database workloads efficiently using Automatic Workload Repository (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 in Saudi Arabia, 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
Frequently asked questions
Our Oracle Database 19c: Performance Management and Tuning course in Saudi Arabia 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 offer practical experience in using Oracle's tuning tools.
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. Optimiser 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 our training course in Riyadh, 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, our certification program is available in locations across GCC regions. We offer comprehensive instruction and training globally, which helps students to gain this important certification.
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!
