Performance Issues with the customers_to_update.sql
Last updated on JULY 10, 2018
Applies to:Oracle Utilities Network Management System - Version 220.127.116.11.0 to 18.104.22.168.0 [Release 2.3]
Oracle Network Management for Utilities - DMS - Version 22.214.171.124.0 to 126.96.36.199.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.
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