My Oracle Support Banner

EM 12c, 13c : Steps to Remove Fragmentation in the EM_EVENT_BUS and EM_NOTIFY_Q AQ Tables Used by Notification Framework (Doc ID 2169325.1)

Last updated on FEBRUARY 22, 2024

Applies to:

Enterprise Manager Base Platform - Version and later
Information in this document applies to any platform.


When the notification subsystem in Enterprise Manager is intensively utilized in Enterprise Manager (EM) 13c Cloud Control, there can be additional delays in delivering the notifications due to fragmentation of the underlying AQ tables in the EM repository database.

An EMDIAG report generated using "repvfy dump notif_health" (see <Note 1426973.1> on how to install it) reports the following result:


[--- 5. Notification diagnostic workflow ---]
Job queue processes : OK
Job queue consistency : OK
Scheduler slave processes : OK
Job queue processes : OK
Broken jobs : OK
Failed jobs : OK
Disabled jobs : OK
Jobs behind schedule : OK
AQ status : OK
EMAIL delivery : OK
PLSQL delivery : OK
SNMP delivery : OK
AQ table fragmentation : FAIL - Event Bus AQ fragmented (EM_EVENT_BUS)
AQ table fragmentation : FAIL - Notification AQ fragmented (EM_NOTIFY_Q)
Extended SQL Trace : OK


The steps in this document provide a way to defragment those tables and may provide performance improvements on notification delivery.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.