Bug 16954972 - Messages Not Purged From Scheduler Event Qtab / High CPU By EMON / Datapump Issue
Last updated on MAY 04, 2017
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 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 :
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