
Learn a top-down approach to diagnosing Oracle database performance issues, pinpointing root causes, drilling down wait events, and tuning the database. This course emphasizes proactive, real-time performance management for DBAs.
Install and configure the essential tools for Oracle database performance tuning: VirtualBox, Oracle Linux 8.2, Oracle Database 19 C software, Xming, PuTTY, WinSCP, and SQL Developer using provided links.
Set up a virtual lab by installing VirtualBox, creating an Oracle Linux 8.2 VM, configuring memory and storage, and installing Oracle Database 19c with proper network, hostname, and RPM preparation.
Configure PuTTY to connect to a VirtualBox VM via the host-only IP, enable SSH and X11 forwarding for GUI Oracle installation, and compare with the built-in terminal for copy-paste.
configure the oracle database server by setting host file entries, installing pre‑install packages, creating oracle users and groups, configuring limits and environment scripts, and preparing startup scripts.
Copy oracle database software to the oracle home, unzip it, and run the software-only single-instance enterprise installer, configuring environment variables via the setup script.
Install the Oracle database with the Dbca utility, configure a CDB with a PDB, set the fast recovery area, enable archiving, and verify with sqlplus as sysdba.
Learn the high level architecture of the Oracle database, including instance and memory structures (SGA, PGA, UGA) and key background processes, plus redo and archive log roles.
Explore how Oracle database versions evolved from v2 to 19c, highlighting key performance features, their impact on tuning, and how DBAs map causes to available options.
Explore core hardware concepts that affect database performance, from CPU and cores to RAM, disk IO, and caching, and learn how bottlenecks, latency, response time, utilization, and saturation impact tuning.
Learn the essential steps and principles before diagnosing database performance issues: proactive vs reactive tuning, the smart criteria, and architecture layers (application, instance, OS) across OLTP and OLAP workloads.
learn the three pillars of performance diagnosis, ASH, AWR, and ADM, using snapshots and reports to diagnose, compare occurrences, and optimize Oracle database performance.
Explore time based instrumentation and db time to diagnose Oracle performance using AWS reports, ash and adme pillars, focusing on CPU, wait events, and foreground versus background processes.
Objective:
Title - Oracle Database Performance Diagnosis And Tuning
Practice makes perfect !
**NOTE: THIS IS NOT SQL TUNING COURSE**
Are you new to Oracle database performance?
Do you want to become a hero in saving the database from revenue bleed?
Are you ready to perform a rapid triage of the performance bottleneck?
Do you need to pretend yourself in a critical situation of performance issue?
Are you obsessed to get a real world knowledge of performance issues?
Are you ready to identify the cause of a performance with in less time?
Do you need to justify the client with artifacts and story telling?
Majority of lab scenarios are presented in this course
This course is for oracle learners who can get distilled knowledge of performance diagnosis
In this course, learners will perform hands on tasks as if like a real time scenario with different situation based tasks
All the parameters will be used in the practical box for different oracle versions
Oracle machine is built in virtual box for simulation of the tasks
Learners can be able to confidently face a performance deviation
Database performance is the core of this course. So you will learn common performance situations faced in your jobs.
Hope the learner who applies for this course has a prior understanding of what oracle database is.
You will be practicing in oracle 19c which is the widely used version all over the world.
Prerequisites:
Oracle Database fundamentals
Linux operating system basics
PC with at least 16 GB, 60 GB HDD, Windows 7,8,or 10 64-bit
CPU core(minimum) - 2
Student category:
Oracle DBA