My Oracle Support Banner

How to Clean Up DMS Message Buildup (Doc ID 1037183.1)

Last updated on FEBRUARY 19, 2020

Applies to:

Oracle Commerce Platform - Version 2006.3 and later
Information in this document applies to any platform.

Goal

This article covers the procedure to clean up Dynamo Messaging System (DMS) message buildup. The DMS message tables may fill up with unhandled messages causing a performance degradation of the SQL JMS system over time. This can affect the performance of the production site as well as the performance of the database.

This occurs when extra DMS clients are registered as subscribers to messages but the clients never run. Messages destined for these clients build up since the messages aren't being read, processed, and deleted.

Note: After cleaning up DMS messages, you may want to consider identifying the root cause, if not known already. On of the most common causes for DMS buildup is server names registered in DMS but no longer active, either due to decommissioning of the server or renaming of the server. For details about server naming in Commerce, see the KM Server Instance Naming in a Cluster (Doc ID 1037524.1)

Solution

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
Goal
Solution

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