My Oracle Support Banner

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

Last updated on NOVEMBER 08, 2021

Applies to:

Oracle Utilities Meter Data Management - Version 2.3.0.0.0 and later
Information in this document applies to any platform.

Goal

**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.

Solution

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
Goal
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.