EMON Slave Idle Wait CAUSE EMON TO BLOCK OTHER SESSIONS
Last updated on FEBRUARY 09, 2018
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 to 188.8.131.52 [Release 11.1 to 11.2]
Information in this document applies to any platform.
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
There where no changes.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms