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 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

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 :

 - AQ$_SCHEDULER_FILEWATCHER_QT_E
 - AQ$_SCHEDULER$_EVENT_QTAB_E

These are connected with queue tables :

 - sys.scheduler_filewatcher_qt
 - sys.scheduler$_event_qtab

these are never purged or removed.

Changes

 The messages may be linked to datapump activity.

Cause

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