Last updated on MAY 04, 2017
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 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
Million Knowledge Articles and hundreds of Community platforms