User-defined metrics allow administrators to extend the reach of Enterprise Manager’s monitoring to conditions specific to their particular environments via custom scripts or SQL queries and function calls. Once these new metrics are defined, they will be monitored, aggregated in the repository and can trigger alerts like any other metric defined in Enterprise Manager. There are two types of user-defined metrics: Operating System and SQL.
Operating System (OS) User-Defined Metrics
Accessed from Host target homepages, these user-defined metrics allow you to implement custom monitoring functions via native OS scripts.
SQL User-Defined Metrics
Accessed from the Database target homepages, these user-defined metrics allow you to implement custom database monitoring using SQL queries or function calls.
If an administrator wants to monitor a particular condition (e.g. check successful completion of monthly system maintenance routines), he can write a custom script that will monitor that condition, then create a user-defined metric that will use his custom script. Each time the metric is evaluated by Enterprise Manager, it will use the script specified by the administrator, relying on that script to return the value of the condition. (SQL user-defined metrics do not use external scripts. You enter SQL directly into the Enterprise Manager user interface at the time of metric creation). Once a user-defined metric is defined, all other monitoring features, such as alerts, notifications, historical collections, are automatically available to it.
Administrators that already have their own library of custom monitoring scripts can leverage Enterprise Manager's monitoring features by integrating their scripts with Enterprise Manager via user-defined metrics. Likewise, existing SQL queries or function calls currently used to monitor database conditions can be easily integrated into Enterprise Manager's monitoring framework.
User-defined metrics are implemented in two phases:
Creating Your Monitoring Script
Registering the Script as a User-Defined Metric
Enterprise Manager Information Roadmap
Copyright © 1996, 2007, Oracle. All rights reserved.