C1-BLGEN Poor Performance In ORMB 126.96.36.199
(Doc ID 2289598.1)
Last updated on MARCH 12, 2021
Applies to:Oracle Financial Services Revenue Management and Billing - Version 188.8.131.52.0 to 184.108.40.206.0 [Release 2]
Information in this document applies to any platform.
C1-BLGEN Poor Performance in ORMB 220.127.116.11
Testing environment is composed of 2 application server cluster, 9 batch server cluster and 2 database server cluster. Each batch server has 4 thread pool workers with 8 threads each. We have executed the base billing jobs in this environment to generate trial bills where the billing mode is set as 'Trial'. About 1,881,949 trial bills were successfully generated by C1-PNDBL. And then 3,727,857 trial bill segments were successfully generated by C1-BLGEN but it took almost 1 hour to complete using 280 threads. This is unacceptable for Visa RPA's limited critical window for its entire nightly batch stream. After extracting the AWR Report, a SELECT statement of C1-BLGEN was seen with a large elapsed time. Please provide solutions to both 'Trial' and 'Actual' billing modes even though this issue was found in 'Trial' mode of C1-BLGEN.
This should run faster.
The issue can be reproduced at will with the following steps:
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