Alter Session/System Set Events

  • Norbert Debes


ALTER SESSION SET EVENTS and ALTER SYSTEM SET EVENTS are undocumented in the Oracle9i and Oracle10g Oracle Database SQL Reference manuals as well as in Oracle Database SQL Language Reference 11g Release 1. The manual Oracle Database Performance Tuning Guide 10g Release 2 contains an ALTER SESSION statement for the presumably best known event 10046 at level 8. Yet, it is undocumented how to switch event 10046 off. The remaining levels of event 10046, which are also very useful, are undocumented too. Furthermore, there are hundreds of other undocumented events that may be set with ALTER SESSION and ALTER SYSTEM, some of which may be very useful too.


Creatin Cute 
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.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Norbert Debes 2009

Authors and Affiliations

  • Norbert Debes

There are no affiliations available

Personalised recommendations