Udemy – Oracle Performance Tuning-Shared Pool Waitevents-Simulated-3

Course Title: Oracle Performance Tuning: Mastering Shared Pool Related Wait Events

Course Description:

In this comprehensive course, you’ll learn how to simulate and resolve shared pool related wait events in Oracle databases. You’ll gain a deep understanding of the internals of the shared pool and learn how to optimize its performance.

Course Objectives:

• Understand the architecture and components of the shared pool
• Identify and simulate shared pool related wait events, such as:
  • latch: cache buffer chains
  • Mutex Internals
  • cursor: pin S
  • library cache: mutex X
  • cursor: pin S wait on X
  • cursor: mutex S
  • Oracle DBA