The Mediation Process Startup Is Becoming Slower (Doc ID 1273070.1)

Last updated on MARCH 07, 2019

Applies to:

Symptoms

Mediation pipeline is becoming slower than before the last servers crash. The module FCT_DuplicateCheck is taking long to start up. The process was taking by max 40 min to start up now it is taking 2 hours.

The Duplicate check files (around 2lakh files) taking 4.5 hrs to process. The store limit and buffer limit values are similar as previous months and the volume of the CDRs for the previous didn't increase that much.

There are two pipelines(GSM, GPRS) in the same registry which uses the Dupchck module, out of which one of the pipelines(GSM) seem to take more time to start. For the GPRS pipeline it processes the duplicate data quickly(~ 5 mins) and for the other pipeline it took almost 4.5 hrs. Another observation is that the timestamp of the duplicate data files in the slower pipeline(GSM) are updated to the processing time, whereas in the other pipeline the timestamps are untouched.

Cause

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