Reviewing Performance Metrics
You can view a variety of performance metrics for the Oracle Database QoS Management system as a whole, or for individual Performance Classes.
Viewing Performance Metrics for All Performance Classes
You can view the performance metrics for your system on the Performance Class Quality of Service page.
After you have configured Oracle Database QoS Management, a short period of time is required for Oracle Database QoS Management to gather performance data and evaluate the performance of the system. After this period of time has passed, you can view the performance metrics for your system. To view the current performance metrics, perform the following steps:
-
Log in to Oracle Enterprise Manager Cloud Control as the cluster administrator. Go to the cluster target page.
-
From the cluster target menu, select Administration, then Quality of Service Management, then View Performance Class Quality of Service.
-
The Performance Class Quality of Service page displays three charts measuring the current performance of each Performance Class that is being monitored:
-
The Performance Satisfaction Metric chart
-
The Demand chart
-
The Average Response Time chart
-
Viewing Performance Metrics for Individual Performance Classes
After you have configured Oracle Database Quality of Service Management, and a short period of time has passed, you can view the performance metrics for a specific Performance Class.
To view the current performance metrics for a Performance Class, perform the following steps:
- On the right-hand side of any graph, in the legend box, click the link that corresponds to the Performance Class for which you want to view the performance metrics.
When you view the performance metrics for an individual Performance Class, you can see two additional graphs:
-
Resource Usage Time
-
Resource Wait Time
Figure 4-5 Resource Wait Time and Resource Usage Time Charts for a Performance Class
Description of "Figure 4-5 Resource Wait Time and Resource Usage Time Charts for a Performance Class" -
Configuring Alerts for Quality of Service Management Events
It is not convenient or efficient to require constant manual monitoring of the Quality of Service Management Dashboard. Instead you can use the Enterprise Manager Cloud Control notification system for reporting negative Performance Satisfaction Metrics (PSMs) that persist for user-specified times.
- From the Cluster Database menu select Monitoring and then select| Metric and Collection Settings.
- Under the Metrics tab, edit the metrics in the categoryQoS Management – Performance Satisfaction Metrics.
For example, if Quality of Service Management uses the database service
sales_svc_pc, then under Negative PSM Duration (seconds), for that service, you might configure a warning alert when the duration is more than 120 seconds and a critical alert if the duration is more than 180 seconds.
Viewing the Resource Wait Times Breakdown
At the bottom of the Dashboard is the Resource Wait Times Breakdown table. This table provides breakdown of resource wait times by Performance Class. For each Performance Class, the bottlenecked resource is the one that has the most wait time. This data is used by Oracle Database QoS Management to produce recommendations. You can also use this data to make manual adjustments to your system.
