Overview Tab
The Performance Analysis Overview tab is the Home mode default view. Prioritized performance alerts, current and baseline normalized system resource utilization, key Oracle performance advisories, and industry best practices are presented side-by-side in a clean, intuitive format. Common graphical elements provide a consistent and intuitive representation of performance deviation and degradation in both relative and absolute terms.
The Overview tab is a real-time monitoring, alerting and tuning digital dashboard. Use it as a reference point and springboard to identify and address which outstanding issues the instance currently faces. Because of its rich analysis and alerting features, the Overview tab immediately pinpoints any resource contention or capacity limitations in need of immediate attention. By increasing real-time service delivery, problem-solving time is greatly reduced.
The user-friendly context-sensitive display and navigation tools give a complete performance report for the specified time frame—the time frame can be configured to show any timeframe from the last 5 minutes to the last 24 hours. Each indicator relates to the entire specified timeframe. This information can be seamlessly incorporated into each user’s work flow and methodology.
Measuring System Health
The Workload gauge is a measurement of total instance activity; the gauge level indicates the proximity of instance activity to that of peak activity. Use it to compare the total session activity during the specified timeframe with that during peak periods.
Note: This measurement is intended to provide an at-a-glance understanding of instance behavior relative to an observed norm and not a measurement of system capacity.
Current activity can easily be determined to be typical, or relatively high or low by comparing it to the baseline range. The clickable color coded alerting feature both details workload metrics and serves as a launch point for further investigation of database behavior.
The Instance Workload activity timeline displays Oracle instance activity (system workload) over the specified recent timeframe, measured by the average number of active sessions. You may toggle between baseline and resources views to gain a better understanding of database activity trends and levels, and of resource consumption.
Oracle Performance displays both the numeric and analogous resource distribution as a percentage of workload activity (displaying the same data as the Real Time Resource Breakdown pie chart). Use both the baseline comparison feature (like the Workload) and performance advisory flags to display resource metric usage details and to launch further investigations. Understand the composition of the present instance activity at-a-glance, and determine specifically which, if any, resource is creating a problem based both on the normative baseline and accepted industry standards.
System Utilization displays system and host parameter resource itemization. As with Oracle Performance, both the baseline comparison and performance advisory flags display resource metric usage details and serve as launch points for further investigation. High system utilization values do indicate full capacity has been reached.