Database Reference
In-Depth Information
Figure 7-7.
Specifying threshold values
7.
Enter or modify the values for the metrics that you want to set. Select only the metrics
that you care about. Remember, values for the metrics should be set according to your
operational goals. You can also remove selected metrics altogether if you don't want them to
be collected. If a threshold value is not set for a metric, no alerts will be sent for the metric.
In addition to specifying thresholds for your metrics, you can modify the collection schedules for the metrics if
those schedules are not in line with your operating goals. For example, the Archive Area Used (%) metric collection
schedule by default is set to collect every 15 minutes. If your database instance has a high transaction rate that
generates a lot of archive redo logs, you may want to modify the collection schedule for the metric to collect at
10-minute intervals instead. Click the link in the Collection Schedule column to modify the schedule. Figure
7-8
shows
a close-up of an Archive Area threshold. The Every 15 Minutes link is what you would click to modify the schedule.
Figure 7-8.
Click the Every 15 Minutes link to modify the schedule for checking Archive Area thresholds
Create additional monitoring templates for each target type that you wish to monitor. In a RAC environment, you
might create templates for listener, cluster database, ASM instance, and host.
