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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2011 Kerry Osborne, Randy Johnson, Tanel Pöder
About this chapter
Cite this chapter
Osborne, K., Johnson, R., Pöder, T. (2011). Exadata Wait Events. In: Expert Oracle Exadata. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-3393-0_10
Download citation
DOI: https://doi.org/10.1007/978-1-4302-3393-0_10
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-3392-3
Online ISBN: 978-1-4302-3393-0
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books