High CPU Consumption Observed In MDM While Loading Interval Reads Via JMS Queues (Doc ID 2711281.1)

Last updated on JULY 05, 2021

Applies to:

Goal

On : 2.2.0.2.0 version, Database

High CPU Consumption Observed in MDM while Loading Interval Reads via JMS queues

High CPU Consumption Observed in MDM while Loading Interval Reads via JMS queues. This has been tested without any custom algorithms in seeder business object. Interval reads are taking almost double time as compared to scalar reads.

For the Scalar read to process 3 registers and the Interval reads at 30 min interval to process 2 reads per meter, and the number of validation the MDM does, need the following for the IMD

1. What is the expected performance of the systems in terms of reads processed per hours ¿ Scalar and Interval
2. What is the recommended configuration for the environment setup to meet the performance requirement to process below data in less than 6 hours?
Scalar: ~ 5 million
Interval: ~3 million (48 intervals per read, Interval Size-30 mins)

Solution

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