Overhead Page
The Overhead page shows user details for wait events for the Oracle RAC Cluster in the Cluster coordination category.
To open the Cluster Overhead page
- Select the Spotlight on Oracle RAC connection in the Spotlight Browser.
-
Click Cluster | Overhead.
Note: Click Activity | Waiting Events Page to show wait events in other categories.
Actions on the Cluster Overhead page
| Data | Description |
|---|---|
| Category |
This is fixed to cluster coordination. |
| 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 Cluster Overhead 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:
|
Cluster Overhead 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