My Oracle Support Banner

Performance Issue After Upgrade to FW V2.2 SP19 (Doc ID 1960596.1)

Last updated on MAY 23, 2019

Applies to:

Oracle Utilities Framework - Version 2.2.0.0.0 to 2.2.0.0.0 [Release 2.2]
Information in this document applies to any platform.

Goal

In this example the customer is having the issue with Tax Utilities global Business Unit (TUGBU) product CCB (Customer Care and Billing). This same issue can occur for other TUGBU products (Oracle Public Sector Revenue Management (PSRM), Oracle Revenue Management and Billing (RMB), and Oracle Utilities Mobile Workforce Management (MWM)) that also sit on Framework (FW) V2.2.0.

The customer is noticing significant slower performance after upgrading to CCB 2.3.1 SP9 / FW V2.2.0 SP19. They have an automated smoke test, before it took 4 minutes to finish in a SP6 environment, right after upgrading to SP9, with same code and same configuration, same environment would take same smoke test now 12 minutes to complete. SA start is much slower now take minutes (10 seconds in SP6), move in/out with one service would take 4 minutes, with two services it would timeout after 5 minutes (default).

The customer has ran DB Stats since the upgrade. Also, the DB instance was rebooted.
 

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.