My Oracle Support Banner

Periodic Estimations Submitting Similar Queries with Diferent Comments causing Performance Degradation (Doc ID 2715690.1)

Last updated on SEPTEMBER 20, 2022

Applies to:

Oracle Utilities Meter Data Management - Version to [Release 2.2 to 2.3]
Information in this document applies to any platform.


**Examples provided in this article do not represent real life personal/confidential information. Please use proper values to your business.**

Periodic Estimations routine is not using binds.

The Oracle Utilities job is submitting similar queries with different comments.  Even though the query is technically the same, the parser doesn't see it as the same query and rebinds for every query causing a lot of unnecessary overhead and slowing the job down and our processing day.


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

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