Database Reference
In-Depth Information
Figure 7-2.
Database metrics and their current threshold settings
Threshold values should be obtained by gathering data during performance or load testing. View the available
metric history to obtain these values while the performance is acceptable. Also define metrics for target availability
such as database instance status. The values selected for critical thresholds should be chosen conservatively so that
you are alerted under only extremely serious conditions, such as when a tablespace is over 97 percent full.
To set values for a metric, follow these steps:
1.
Click a metric category such as Tablespaces Full. These categories are listed to the left
in Figure
7-2
.
2.
Click a specific metric such as Tablespace Space Used (%).
3.
Click the Modify Thresholds button. You should see a dialog box like the one in Figure
7-3
.
