EMON Slave Idle Wait CAUSE EMON TO BLOCK OTHER SESSIONS (Doc ID 2040053.1)

Last updated on AUGUST 29, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 to 11.2.0.4 [Release 11.1 to 11.2]
Information in this document applies to any platform.

Symptoms

EMON slave idle wait is showing high in AWR report.
Customer complained that the database and queries are running slow.

In the AWR report (Background Wait Events) 

Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn % bg time
PX Idle Wait 166 0 14,838 89387 0.09
EMON slave idle wait 2,165 100 10,827 5001 1.20                  

Following error was reported in the database alert log

Errors in file /u01/app/diag/rdbms/dbname/db_instance/trace/db_instance_j000_49254.trc:
ORA-12012: error on auto execute of job 19743
ORA-24247: network access denied by access control list (ACL)
ORA-06512: at "SYS.UTL_TCP", line 17
ORA-06512: at "SYS.UTL_TCP", line 267
ORA-06512: at "SYS.UTL_SMTP", line 161
ORA-06512: at "SYS.UTL_SMTP", line 197
ORA-06512: at "IDMS_MDCEU.SII_EMAIL", line 25
ORA-06512: at line 1

Changes

 There where no changes. 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms