The Waiting Events page shows user details for wait events for the Oracle instance. Deal With Wait Events You can view waiting events data for all waiting events, or for specified events or event categories.
To open the Waiting Events page
Click Activity | Waiting Events.
Data on the Wait Events page
Choose an option from the Category list to display details about a specified category of waiting event. A category may contain several event types.
|Wait Event Analysis||Choose an option from the Wait Event Analysis list to display details about a specified type of waiting event.|
|Predictive Diagnostics (if available)||
How will the selected category of Waiting events ("bottlenecks") affect future database throughput and response time? View Spotlight's Predictive Diagnostics analysis (if available). Impending Bottlenecks - Timed Statistics
Charts on the Wait Events page
The historical Wait Activity chart displays the rate at which waiting events occur (measured in milliseconds waited per second) over the specified period.
The Wait histogram displays the number of wait events of a given duration (measured in milliseconds).
Note: The Wait Histogram contains data only when a wait category (and, optionally, a wait event) is selected in the drop-down list at the top of the page.
Wait Events Sub Pages
The Waiting Events Information sub-pages display tables that provide more detailed information about the waiting events. The pages are: