Event 10027 and Deadlock Diagnosis

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.