EP Performance Problems (Doc ID 1494076.1)

Last updated on MARCH 01, 2019

Applies to:

Goal

We have a requirement in CDR processing through Oracle Network Mediation where one CDR is to be burst into two or more CDRs. The group of CDRs are to be processed together and in the end it should be written as separate output CDRs. In order to achieve this through ONM we are using List type variable provided in NPL.
While it is very straight forward to group the CDRs into one through List but we have not found any function around the List object of NPL so that we can read the data from it to create separate CDRs.

In order to achieve this we have used Java Hook which we are calling from NPL to get each of the record from the list in a loop. While doing this we have observed that it is causing steep decline in performance and we are not able to meet the performance requirement. We would like to know the following:

1. Is there any function built around List type variable in NPL which can be used to read records from it directly instead of using java hook. We are asking this because we have not found any functionality around List type variable in NPL (We might have missed something present in NPL).
2. If there is no function around list are you planning to built one. I think it is very much required since record burst is normal business requirement of CDR processing and solution for this should be present as part of NPL.
3. If possible please suggest better solution which is present in NPL but we are not aware of or not documented.
 

Solution

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