Oracle Buffer Cache Performance Analysis & Tuning

• Unlock deep tuning secrets • Understand the buffer cache • Sessions recorded • Live & interactive class •


5 sessions    Standard Price - $649   Email for possible discount.

Oracle Buffer Cache Performance Analysis & Tuning teaches you how to unlock Oracle's block buffer cache deep tuning secrets. A dizzying array of unlimited requirements and limited capacity can result in massive CPU consumption and wait events such as read by other session, db file sequential reads, latch: cache buffer chains, latch: cache buffer LRU chain, write complete waits, and buffer busy waits. This class will teach you how to identify when the buffer cache internal memory structures are being stressed to the point of hindering performance, how they work and how to resolve the performance issues.

Dates & Registration

Why should I attend this class?

At least one of the top five wait events almost always contains a buffer cache related event. This means every Oracle DBA must intimately understand the buffer cache. Through constant demonstrations and mind-expanding lectures, Craig will guide you through the jungle of algorithms and information. Once you understand how all the moving pieces work together, developing solutions becomes second nature. In other words, your performance tuning skills will become much stronger.

You will be able to:

  • Interact directly with Craig as he performs demonstrations and teaches
  • Explain to others how the key buffer cache structures work together
  • Find the true "top" SQL contributing to buffer cache issues
  • Understand how OS limitations are contributing to the performance situation
  • Correctly adjust documented and un-documented parameters
  • Understand how internal Oracle buffer cache algorithms work
  • Use your knowledge of the cache buffer chains, least recently used lists and dirty lists to improve performance
  • Watch and listen to Craig as he explains how to diagnose the problems and derives their solutions

Class Outline

Session 1. Oracle buffer cache fundamentals

Session 2. Cache buffer chain internals, performance diagnosis and tuning

Session 3. Buffer busy wait event causes, performance diagnosis and tuning

Session 4. Free buffer wait event causes, performance diagnosis and tuning

Session 5. Case study using an AWR report


Class Hours: There are 10 hours of live, interactive webinar training divided into five 2-hour sessions. To maximize learning and to work with your busy schedule, there will be a 1-3 day gap between sessions.

Class Structure: OraPub believes you learn more when you freely and actively engage during the training. This is why each session is full of live demonstrations and lots of Q&A time. Craig types a lot during class. This "session log" is available after each session. If you miss a session, you are free to attend that session when the class is offered again.

Watching Recorded Sessions: Each session is recorded and used to create a unique web page just for your class. The recordings can be streamed using any device, but not downloaded. You can re-watch the videos as many times as you wish. The videos and your unique class web page will be available for three years!

Class Homework: After each live session, homework will be available for you to download. The homework consists of a series of investigative questions which allow you to personally experience the session concepts, increasing your retention. Any slides presented during the sessions will also be available for your download.

Class Requirements:

You will need:

  • The ability to connect to the online training over the internet, hosted by You do not need a microphone. Craig is the only one that speaks but all students will be typing their questions, answers and comments... it's very lively! Oracle software is not required during the live training.
  • Time to do the homework. You can expect the homework to take between 30 to 90 minutes.
  • The ability to connect to an active Oracle system. You can connect to Oracle using the tool of your choice, such as SQL*Plus or SQL Developer. You will also need access to the v$ and DBA views and the ability to generate either an AWR or Statspack report. We do not use OEM. If you can tune Oracle from the command line, you can tune Oracle using any respectable GUI tool. Also, Craig only uses SQLPlus, so you can type exactly what he types.

Bonus: You will get free insight from Craig for one of your AWR/Statspack reports. You do the analysis, email your findings to Craig, and he will give you free feedback!

Oracle Buffer Cache Performance Analysis & Tuning | OraPub