Duplicate Identification Program And Automerge Poor Performance (Doc ID 553411.1)

Last updated on AUGUST 21, 2012

Applies to:

Oracle Trading Community - Version 11.5.10.2 to 11.5.10.3 [Release 11.5]
Information in this document applies to any platform.

Symptoms

Module DQM Duplicate Identification Program (ARHDQBD) is taking too long, and Automerge spawned by this program never ends.

Process DQM Duplicate Identification Program  is running three workers (ARHDQBDW module: DQM Duplicate Identification Worker) and each of these are taking 19 hours to run.

After applying <Patch 5351721>, the performance improved, and now this process is taking 2 or 3 hours.

When all of these workers finish, then the DQM Duplicate Identification Program runs Automerge (ARHAMRGP module: Automerge). This process just never ends.

Cause

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