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 SEPTEMBER 04, 2021

Applies to:

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


When the notification subsystem is intensively utilized in Enterprise Manager Cloud Control, there can be additional delays in delivering the notifications due to fragmentation of 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) will report the below:


[--- 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 de-fragment those tables for 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.