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/53531 EnrolledEnrolled Learners
4.9/53531 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
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
Successful completion of the course will help you to:
1
Learn Oracle 19c tuning with AWR, ADDM, Statspack for optimal performance and troubleshoot issues using SQL Developer and Wait Event Statistics effectively
2
Monitor performance in real-time using TKPROF, SQL Trace and Emergency Monitoring tools
3
Improve SQL execution using SQL Plan Management and SQL Tuning Advisor
4
Develop skills in analysing Oracle In-Memory Column Store for enhanced performance
5
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, 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 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:
- Improved career opportunities
- Certified expertise in enhancing Oracle performance
- Hands-on practical skills in resolving slow queries
- Get globally recognised by employers in the IT sector
- Progress towards advanced Oracle credentials
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!
