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 JUNE 29, 2017

Applies to:

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

Goal

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 ---]
[----------------------------------------------------------------------------]
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 de-fragment those tables for performance improvements on notification delivery.

Solution

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