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"
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