C1-BLGEN Poor Performance In ORMB 188.8.131.52
(Doc ID 2289598.1)
Last updated on JULY 27, 2017
Applies to:Oracle Financial Services Revenue Management and Billing - Version 184.108.40.206.0 to 220.127.116.11.0 [Release 2]
Information in this document applies to any platform.
C1-BLGEN Poor Performance in ORMB 18.104.22.168
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