How to clear alerts in Grid Control

[Database Administrator]

Hi all,

we've just impemented Grid Control (10g release2 on SLES9) to monitor
our databases, application server and lots of other stuff. However
after installation and configuration of 135 targets I have a lot of
alerts and policy violations. Is there a quick or easy way to get rid
of these messages? I was able to select some of them and remove them
with a 'clear' button but that was only a small part.

tia,
Bert Jan Meinders

[lucytude]

How to clear Oracle Enterprise Manager’s Alert
first, check this

- SELECT * FROM SYSMAN.MGMT_CURRENT_SEVERITY ORDER BY COLLECTION_TIMESTAMP



then delete
delete from mgmt_severity where target_guid=' ' and metric_guid='';