My Oracle Support Banner

Slow performance when performing queries on EIP framework (Doc ID 854741.1)

Last updated on FEBRUARY 03, 2022

Applies to:

Oracle Utilities Rate Management - Version 4.5 to DNU4.53
Oracle Utilities Market Settlements Management - Version 4.5 to DNU4.53
Oracle Utilities Energy Information Platform - Version 4.5 to DNU4.53
Oracle Utilities Meter Data Management - Version 4.5 to DNU4.53
Oracle Utilities Billing Component - Version 4.5 to DNU4.53
Information in this document applies to any platform.

Symptoms

The issue concerns the basic "select" SQL statement generated by the EIP framework. Apparently, the EIP framework is passing a value (that is not a number) into the "where" SQL clause condition; as a result, a function (TO_BINARY_DOUBLE) is applied to the input parameter of the "select" SQL clause. This is forcing Oracle to skip the use of the index that should be used as it is linked on the target table. This causes performance issues.

The question is: Why the input parameter passed from the EIP framework to the database has a type that is not a number?

Cause

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
Symptoms
Cause
Solution
References

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