Database Reference
In-Depth Information
Chapter 7
Managing and Monitoring
Best Practices
by Leighton Nelson
Oracle Enterprise Manager Cloud Control 12c is built from the ground up to manage and monitor your enterprise
infrastructure and applications across the entire IT stack. To effectively manage your environment, various techniques
and best practices should be followed. Monitoring your environment ensures that no component goes unwatched.
By using events, metrics, and incidents, you can provide yourself a comprehensive picture of the environment at any
point in time.
This chapter presents some of the best practices to apply to monitoring and managing your environment with
EM12c. The following best-practice areas are discussed:
•
Metric thresholds
•
Monitoring templates
•
Administration groups
•
Template collections
•
Synchronization schedules
•
Incident management
Metric Thresholds
Metric thresholds
are the main features when it comes to monitoring. They enable you to be proactive so you can
identify issues and address them in a timely manner. Enterprise Manager Cloud Control includes many types of
metrics, which can be used for monitoring targets. Several classes of metrics are available, depending on the type of
target. Metric thresholds should be configured so that alerts are triggered and sent via notifications to administrators.
Two levels of severity are associated with metric thresholds:
warning
and
critical
. For example, you may set a
metric threshold for a tablespace in the database to send a warning alert when the tablespace becomes more than
80 percent full. Then you might set another threshold to send a critical alert when the tablespace becomes more than
95 percent full. A warning threshold will allow enough time to address issues before they become critical. Critical
alerts would indicate an impending problem and require immediate action.
When defining your thresholds, first determine the important components on which thresholds should be set.
This could include database instances, listeners, and filesystems. Metrics can then be selected from EM12c for each
target type.
