Oracle Database 19c: Performance Management and Tuning Course in US
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/54.9/5Overview
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
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
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
After finishing the training, you will be able to:
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 the US, 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
The Oracle Database 19c: Performance Management and Tuning Course in the US offers a learning experience designed to help database professionals analyse, diagnose and optimise the performance of Oracle databases. Our course is delivered by certified Oracle professionals with real-world experience in performance troubleshooting, SQL tuning and memory optimisation.
The Oracle Database 19c: Performance Management and Tuning training in the US is ideal for IT professionals who work with Oracle databases and want to enhance their performance optimisation skills. The ideal candidates are:
● Oracle Database Administrators (DBAs)
● SQL Developers and PL/SQL Programmers
● System and Infrastructure Engineers
● Performance Engineers
● Cloud Engineers and Architects
● Technical Consultants and Support Engineers
In the Oracle Database 19c Course in the US, you gain hands-on experience with powerful tools and proven techniques Oracle professionals use to identify and resolve database performance issues efficiently. These tools and techniques are:
● AWR (Automatic Workload Repository)
● ADDM (Automatic Database Diagnostic Monitor)
● ASH (Active Session History)
● SQL Tuning Advisor & SQL Access Advisor
● TKPROF
● SQL Trace
● SQL Tuning
● Instance and Memory Tuning
● Event & Bottleneck Analysis
● Network and RAC Tuning
The Oracle Database 19c: Performance Management and Tuning training can boost your career prospects in the US. This is useful in industries that rely heavily on high-performance database systems such as banking, telecom, government, logistics and cloud services.
Our course helps you in mastering performance tuning that makes you a specialist, not just a generalist DBA. Also, we prepare you for the Oracle Certified Professional (OCP) credential via the 1Z0-084 exam, enhancing your global credibility.
The Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) are two of the most powerful diagnostic tools in Oracle Database 19c that play a vital role in database performance tuning. AWR captures and stores detailed performance statistics to provide a historical view of the database's workload. ADDM analyses AWR data and identifies performance bottlenecks and their root causes. Both are taught in our Oracle Database 19c course in the US.
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!