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 11.2.0.3 and laterOracle 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.
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
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |