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 AUGUST 02, 2022

Applies to:

Goal

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 ---]
[----------------------------------------------------------------------------]

DBMS_SCHEDULER status : OK
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.

Solution

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