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 220.127.116.11.0 and later
Information in this document applies to any platform.
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