What you'll learn

Skills you'll gain

There are 12 modules in this course

The course begins by addressing critical performance challenges, including CPU bottlenecks and disk I/O optimization. Progress into advanced topics like maintaining in-production indexes, handling row migration and chaining, and diagnosing table fragmentation. Engage with powerful features like table compression and the In-Memory Column Store to boost data retrieval speeds. Learn to optimize database connections and leverage SQL Performance Analyzer for precise query tuning. Real-world scenarios and hands-on exercises solidify your expertise in cutting-edge tools such as Database Replay and EM Express, ensuring you can handle live performance challenges confidently. The final modules focus on Linux OS performance monitoring and SQL Performance Analyzer, empowering you to manage both database and system-level performance with ease. This course is ideal for intermediate to advanced learners with prior Oracle database knowledge. Whether you're a database administrator or an IT professional, this program equips you with the skills to maintain high-performance Oracle environments.

Tuning Disk IO Operations in Oracle Database

Maintaining In-Production Indexes for Performance

Handling Row Migration and Row Chaining

Diagnosing Table Fragmentation

Using Table Compression

Introducing In-Memory Column Store

Optimizing Database Connection

Monitoring Oracle Database Performance Using EM Database Express

Monitoring OS Performance Using Linux Utilities

Using SQL Performance Analyzer

Using Database Replay

Explore more from Data Management