Bug 16954972 - Messages Not Purged From Scheduler Event Qtab / High CPU By EMON / Datapump Issue
(Doc ID 1566242.1)
Last updated on FEBRUARY 14, 2019
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A 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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document