Advertisement

Exadata Wait Events

  • Kerry Osborne
  • Randy Johnson
  • Tanel Pöder

Abstract

The Oracle database is a very well instrumented piece of code, and it has been so for quite a while. It keeps track of the amount of time spent in discrete operations via the use of wait events. While the database software is quite complex, wait event analysis allows performance analysts to determine precisely where the database is spending its time. Many difficult performance problems can be resolved by analyzing these wait events. The introduction of Exadata has resulted in the creation of several new wait events to support the unique operations that are performed on the platform. This chapter will focus on describing these new events and how they relate to the activities actually being performed, while contrasting them with the wait events used by the database on non-Exadata platforms. It will also describe a few wait events that aren’t specific to Exadata but play an important role on Exadata platforms.

Keywords

Trace File Parallel Query Reliable Message aTPS Event Path Read 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Kerry Osborne, Randy Johnson, Tanel Pöder 2011

Authors and Affiliations

  • Kerry Osborne
  • Randy Johnson
  • Tanel Pöder

There are no affiliations available

Personalised recommendations