Waiting Events Page
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
- Select the Spotlight on Oracle connection in the Spotlight Browser.
-
Click Activity | Waiting Events.
Data on the Wait Events page
| Data | Description |
|---|---|
| Category |
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
| Chart | Description | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Wait Activity |
The historical Wait Activity chart displays the rate at which waiting events occur (measured in milliseconds waited per second) over the specified period.
| ||||||||||
| Wait Histogram |
The Wait histogram displays the number of wait events of a given duration (measured in milliseconds). For example:
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:
- Current Users Page
- All Users Page
- Active Session History Page (if enabled)
- Active Workload History Page (if enabled)
- Segments Page
- SQL Page
- Category Events Page