Modifying EM Metric Threshold in bulk

1. Login.

./emcli login -username=sysman

2. Select from oms repository.

select './emcli modify_threshold -target_name="'||A.target_name||'" -target_type="oracle_database" -metric="sizeOfOSAuditFiles" -column="FILE_SIZE" -warning_threshold="1000" -critical_threshold="2000" -force' from sysman.MGMT$METRIC_COLLECTION A
where A.target_type='oracle_database' and A.metric_name='sizeOfOSAuditFiles'

3. Execute the result.