My Oracle Support Banner

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

Last updated on NOVEMBER 07, 2018

Applies to:

Oracle Utilities Rate Management - Version: 4.5 to 4.53
LODESTAR EIP - Version: 4.5 to 4.53]
Oracle Utilities Meter Data Management - Version: 4.5 to 4.53]
Oracle Utilities Billing Component - Version: 4.5 to 4.53]
Oracle Utilities Quotations Management - Version: 4.5 to 4.53]
Information in this document applies to any platform.
***Checked for relevance on 25-May-2011***

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.