Contacts     ->      ICQ:    699 512 265,         E-Mail: CerebroSQL@gmail.com

  • YouTube Social  Icon

Top wait events database Oracle

To understand the load profile of the base, waiting for an event encountered one of the key roles played when using queries.

The core of the program continuously monitors the top wait events for sessions, bringing the main one (designating the main contribution) in the main window

For a complete list of wait events and their contribution to the work of the current session as a percentage press "TOP Wait event"

Window tabs

  • Sesstat - stamp view of expectations for the current session

  • Sysstat - stamp view of expectations for the database as a whole

  • SQL - query text for stamp expectations. In the transition from any of the 2 previous tabs, you are asked to provide information to its formation

 

View event description
In the "[DBInfo] TOP wait event" double-click your mouse on the event of interest