Performance Issues with the customers_to_update.sql

(Doc ID 2417361.1)

Last updated on JULY 10, 2018

Applies to:

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

Symptoms

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.


Changes

 

Cause

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