My Oracle Support Banner

Performance Issues with the customers_to_update.sql (Doc ID 2417361.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle Utilities Network Management System - Version to [Release 2.3]
Oracle Network Management for Utilities - DMS - Version to [Release 2.3]
Information in this document applies to any platform.


There are performance issues with product_customers_to_update.sql.

There are some significant issues with the performance of the <project>_customers_to_update.sql, that gets executed by product_update_customers.ces.  The <project>_customers_to_update.sql is similar to the product_customers_to_update with just a few more fields that are compared.  The part of the sql that seems to give the problem is the same as the product version.  

There is intensive I/Os and sorts each time this query is executed.

When the base table CU_SERVICE_POINTS and CU_SERVICE_POINTS_CIS gets big, the impact of the I/Os increases exponentially. 
Currently the process is doing the updates row-by-row, which is not efficient if we have to process thousands or even millions of the rows.


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
 Fix Description

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