Generate SQL to remove alerts from specific targets: 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 mgmt_targets t inner join mgmt_current_severity s on t.target_guid = s.target_guid where target_name like '&TARGET'; Sample output: TARGET_NAME TARGET_TYPE COLLECTION_TIMESTAMP MESSAGE EM_SEVERITY Denilson host 10/3/2010 12:03:30 PM Memory Utilization is 82.46%, crossed warning (80) or critical (95) threshold. exec em_severity.delete_current_severity('4D11D922179D4A9532397244E91478AE','86821B5F0CE858D6E4A7F7390E88B73C',' ')
Blog com dicas, scripts, How-to para DBA´s e Desenvolvedores ORACLE.