събота, 30 септември 2017 г.

OEM Deleting Alert Manually

SQL> alter session set current_schema=sysman;

Session altered.

SQL> select target_guid, metric_guid, key_value, message from mgmt_current_severity where message like 'User SYS logged on %';


TARGET_GUID METRIC_GUID
-------------------------------- --------------------------------
KEY_VALUE
--------------------------------------------------------------------------------
MESSAGE
--------------------------------------------------------------------------------
A7FDF4A99855512BFEDA32F2A246BDE1 D6438569B496BC9205481E8A70F92F1E SvYS_vaso10
User SYS logged on from vaso10.

SQL> exec EM_SEVERITY.delete_current_severity('A7FDF4A99855512BFEDA32F2A246BDE1','D6438569B496BC9205481E8A70F92F1E','SYS_vaso10');

PL/SQL procedure successfully completed.

SQL> commit;