My Oracle Support Banner

CM-IMMC2 Batch Performance Issue While Executing Query Invoked Product Code (Doc ID 2766961.1)

Last updated on APRIL 07, 2021

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.9.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 2.9.0.0.0 version, BT - Batch

ACTUAL BEHAVIOR
---------------
CM-IMMC2 batch performance issue while executing query invoked product code

CM-IMMC2 batch is taking long to complete the batch, and it has been observed that there are long running query from the base code, which are taking more time, hence the batch. Attached is the detailed analysis and suggested solution of the query which is causing bottleneck and needs fix.

CM-IMMC2 batch performance issue while executing query invoked product code.
Problem Statement
CM-IMMC2 batch is taking long to complete the batch, and it has been observed that there are long running query from the base code, which are taking more time, hence the batch.
From the below screen shot, we can see 90% of the threads are in progress status and stuck in the processing.

The “In Progress” threads are distributed across threadpool worker in the cluster, so each threadpool worker is engage in this process, which impact processing of the overall performance.

EXPECTED BEHAVIOR
-----------------------
No performance issue.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run CM-IMMC2 batch

Cause

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
Symptoms
Cause
Solution
References


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