Performance Issue on Pin_bill_accts

(Doc ID 2344214.1)

Last updated on JANUARY 11, 2018

Applies to:

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


On Oracle Communications Billing and Revenue Management(BRM), version,

The user has recently upgraded the system from BRM 7.4PS14 / AIX 6.1 to BRM 7.5PS17 / Solaris 10 with Oracle DataBase 11g.
During the last execution of the pin_bill_accts process, it reached the configured fetch size limit, and upon retry to make a new fetch, it became locked.

Here is the current configuration in $PIN_HOME/apps/pin_billd/pin.conf for the fetch size:

Returned 13428503 registers.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms