Bug 16954972 - Messages Not Purged From Scheduler Event Qtab / High CPU By EMON / Datapump Issue

(Doc ID 1566242.1)

Last updated on MAY 04, 2017

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


Possibly high CPU from EMON process due to large number of messages in exception queues are detailed below :

connect / as sysdba
select count(*), queue, consumer_name from aq$scheduler$_event_qtab group by queue, consumer_name;
select count(*), queue, consumer_name from aq$scheduler_filewatcher_qt group by queue, consumer_name;

shows messages existing in following exception queues :


These are connected with queue tables :

 - sys.scheduler_filewatcher_qt
 - sys.scheduler$_event_qtab

these are never purged or removed.


 The messages may be linked to datapump activity.


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