Here I'll show you how to clear this unnecessary information.
login into database with sysman user and execute this script:
SELECT t.target_name, t.target_type, collection_timestamp, MESSAGE, 'exec em_severity.delete_current_severity(''' || t.target_guid || ''',''' || metric_guid || ''',''' || key_value || ''')' em_severity FROM sysman.mgmt_targets t INNER JOIN sysman.mgmt_current_severity s ON t.target_guid = s.target_guid;
result:
after that run this scripts
SQL> exec em_severity.delete_current_severity('C894D538793FFA3B4727BCBCD84D4925', '3F2BBE6BF105C0D16A3710F2868B8399','RECOVERY AREA'); PL/SQL procedure successfully completed. SQL> commit; Commit complete.
same way you can clear entire alerts.
No comments:
Post a Comment