This control is applicable to environments where Oracle Data Guard is installed. It shows the overhead of Data Guard on the primary database.
The design is similar to the Average Active Sessions (AAS) guage.
- Dark Shaded Area - Amount of time sessions spend waiting on data guard.
- Light Shaded Area - Amount of time sessions spend on other tasks.
- White Line - CPU Limit.
A value greater than the CPU limit, indicates potential performance issues. This is shown on the Average Active Sessions gauge as either of the colored bars passing the vertical white line. How far the colored bar has passed the vertical white line indicates the severity of the performance issue. A value far greater than the CPU limit indicates that the database is experiencing bottlenecks.
Note: Alarms on this component are raised on the Spotlight on Oracle Data Guard Home Page, not the Spotlight on Oracle home page.