My Oracle Support Banner

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

Last updated on AUGUST 30, 2021

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

EMON secondary 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 secondary idle wait 2,165 100 10,827 5001 1.20                  

Following error was reported in the database alert log

Errors in file <path>/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 "USER_TEST.PROC_TEST", line 25
ORA-06512: at line 1

Changes

 There where no changes. 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.