Skip to content

Make DBA Life Easy

  • Home
  • Blog
  • Investment
  • About
  • Contact
  • Disclaimer
  • Subscribe
Make DBA Life Easy

Tag: Metric Extension ( ME )

Materialized View : OEM Monitoring and Alerting through Metric Extension( ME ), Incident Rule ( IR ) and Self Healing through Corrective Action( CA )

In previous posts, we have created following related posts to monitor FRA and auto backup archive logs:

  1. Create a Metric Extension (ME) to Monitor FRA Usage on OEM
  2. Create an Incident Rule for Metric Extension ( ME ) to Monitor FRA Used in OEM
  3. 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.

SubscribeSubmitting form
Log in
Unknown's avatarAuthor dbalifeeasyPosted on December 1, 2021Categories OEM13c, Premium ContentTags CA Corrective Action, Materialized View monitoring, Metric Extension ( ME ), STALE materialized viewsLeave a comment on Materialized View : OEM Monitoring and Alerting through Metric Extension( ME ), Incident Rule ( IR ) and Self Healing through Corrective Action( CA )

Google Translate

SEARCH

Calendar

December 2025
M T W T F S S
1234567
891011121314
15161718192021
22232425262728
293031  
« Nov    

Archives

Blog Stats

  • 1,435,528 hits

Categories

  • AWS (9)
  • GoldenGate (13)
    • Config (2)
    • Docs (1)
    • Exam & Interview Q/A (1)
    • How To (1)
    • Install and Upgrade (2)
    • JAgent (1)
    • OGG ERROR (4)
    • OGGMON (1)
  • Linux (29)
  • MySQL (4)
    • Install and Upgrade (3)
    • Startup and Shutdown (1)
  • Oracle (638)
    • 12c/13c/18c/19c/20x New Features (9)
    • ADR (2)
    • ASM (34)
    • Audit (4)
    • AWR (5)
    • BI Report (3)
    • CDB/PDB (27)
    • CHM (14)
    • Client (14)
    • CMU (2)
    • Configuration (31)
    • Corruptions (3)
    • DataGuard (60)
    • DataPump (17)
    • dbms_scheduler (6)
    • Exadata & ExaCC (10)
    • FLASHBACK (5)
    • GI and RAC (127)
    • Globalization (1)
    • Install Upgrade and Patches (70)
    • JAVA (2)
    • Materialized View (7)
    • OCI (5)
      • ADW / ATP (3)
      • Object Storage (1)
      • Veridata (1)
    • OEM( Oracle Enterprise Manager) (94)
      • OEM 12c (9)
      • OEM13c (87)
    • ORA- ERRORS (65)
    • oracle advanced compression (4)
    • ORMB (13)
    • Partitioning (12)
    • Performance Tunning (28)
    • RMAN Restore and Recovery (30)
    • Security (13)
    • Services (2)
    • SQL Net (16)
    • SQL Scripts For DBA (27)
    • Statistics (1)
    • TDE (7)
    • TOOLS( AHF TFA ORAchk EXAchk ) (6)
    • TTS (1)
    • Upgrade (2)
    • User Privileges and Roles (19)
    • Weblogic (1)
  • PostgreSQL (31)
    • Client (4)
    • Extension (6)
    • Install and Upgrade (8)
    • Migration (4)
    • Objects (4)
    • Performance Tuning (1)
    • Privileges (1)
    • SQL Scripts for DBA (4)
    • Vacuum (4)
  • Premium Content (231)
  • SQL Server (27)
    • Always On (3)
    • Backup and Restore (2)
    • Client (1)
    • Install Patch and Upgrade (4)
    • Security (3)
    • Space (2)
    • SQL Scripts for DBA (6)
    • SSMA (4)
    • Versions (2)
  • VirtualBox (14)
  • Windows (15)

Meta

  • Create account
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.com
  • Home
  • Blog
  • Investment
  • About
  • Contact
  • Disclaimer
  • Subscribe
Make DBA Life Easy Blog at WordPress.com.
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Subscribe Subscribed
    • Make DBA Life Easy
    • Join 58 other subscribers
    • Already have a WordPress.com account? Log in now.
    • Make DBA Life Easy
    • Subscribe Subscribed
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar