Problem Statement: Lets assume as a DBA you wrote some script which moves old partitioned data of a table into some monthly archival tablespace. After data movement you found that utilization of archival tablespace is more than 90 percent. Since there will not be any DML operation on those data so you don’t want any OEM alert from those archival tablespace. This document will guide you how to achieve this requirement using OEM.
In my case there are at least 12 tablespaces which is
dedicated for each month and starts with a string
Follow below navigation.
Oracle Database>Monitoring>Metric and Collection
Settings
Click on pencil icon from below
Now you can see below that tablespace name selected as all
others which means it will send alert
for all tablespaces but you want to exclude certain tablespace which starts
with a matching string
Click on add button and leave warning and critical threshold
which means any tableapce whose name starts with IND will be excluded as we
have disabled without putting any threshold value.Now click on continue.
Click on ok button to save it in repository
From the incident manager you can validate that those alert is now cleared.
Hope you have learnt something useful...
No comments:
Post a Comment