Abstract
Part 1 introduced the partially documented initialization parameter EVENT and some of the benefits that may be realized by using it for troubleshooting. Part 3 expands on that material in the sense that the events it discusses may be set using the parameter EVENT or the SQL statements ALTER SESSION/SYSTEM. The difference between these approaches is that solely the parameter EVENT ensures that the configuration is both persistent and pertains to the entire lifetime of an ORACLE DBMS instance. The subsequent chapters address events for deadlock diagnosis, collection of performance data, and Oracle Net packet dumps.
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
© 2009 Norbert Debes
About this chapter
Cite this chapter
Debes, N. (2009). Event 10027 and Deadlock Diagnosis. In: Secrets of the Oracle Database. Apress. https://doi.org/10.1007/978-1-4302-1953-8_5
Download citation
DOI: https://doi.org/10.1007/978-1-4302-1953-8_5
Publisher Name: Apress
Print ISBN: 978-1-4302-1952-1
Online ISBN: 978-1-4302-1953-8
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books