OCM 11g Preparation - Create and monitor alerts

In this chapter you must know how to configure Metric Thresholds. Each target has a screen to configure all of them in one place.

It's a menu item called "Metric and Policy Settings". However, you can also define in metrics in other places.

E.g: If you need to define the Used% for tablespace USERS, you can go directly in the tablespace menu item, edit the USERS one and define the metrics there.

The best way to practice this topic is creating random questions to yourself and check if you are able to apply them in less than 1 minute:

• Define an alert if the number of sessions waiting for I/O is bigger than 10
• If the Soft Parse (%) is lower than 80
• If your database finds any ORA-20118 error (raise it using a PL/SQL code to check if it is working).
• Create one user defined metric to test something like "total sessions running inserts" and check the alerts and warnings.
• Create also an Adaptive Metric and play with Adaptive Thresholds.

Path to Documentation:

Administrator’s Guide -> 1 Monitoring
Administrator’s Guide -> 4 User-Defined Metrics

+1