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 22.214.171.124.0 to 126.96.36.199.0 [Release 2.3]
Oracle Network Management for Utilities - DMS - Version 188.8.131.52.0 to 184.108.40.206.0 [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!