OEM (version 13c) pages the on-call DBA at night on
ORA-01013 (user requested cancel of current operation)
It's probably due to the timeout of an inefficient SQL to check tablespace usage according to
Em12c : ORA-01013: Metric Collection Error reported as Critical (Doc ID 2216222.1)
Slow Performance Oracle Enterprise Manager SQL Metrics SQL statement (SQL ID: 4d43by1zzjfna) Automatically Run (Doc ID 2266608.1)
Select from DBA_AUTOTASK_CLIENT raises ORA-1013 from EMAGENT (Doc ID 2278403.1)
The solutions provided in those notes are irrelevant, either because the SQL in the note runs within a second for us, or the recycle bin is empty. Regardless, I'd like to ignore such a harmless error in OEM. After all, cancelling a long-running SQL either by a human or a job is not critical to us. Is there a way to configure OEM to ignore this "error"? Thanks.