In previous posts, we have created following related posts to monitor FRA and auto backup archive logs:
- Create a Metric Extension (ME) to Monitor FRA Usage on OEM
- Create an Incident Rule for Metric Extension ( ME ) to Monitor FRA Used in OEM
- Use Corrective Action ( CA ) to Automate Archivelog Backup When FRA Usage is Over Threshold of Metric Extension ( ME ) in OEM
In this post, we will do the same thing for Materialized Views to monitor, alert and self heal the materialized views.
- Create a Metric Extension (ME) to Monitor Materialized Views on OEM
- Create an Incident Rule for Metric Extension ( ME ) to Monitor Materialized Views in OEM
- Use Corrective Action ( CA ) to compile / refresh Materialized Views in OEM
Subscribe to get access
Read more of this content when you subscribe today.
Make DBA Life Easy 