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 184.108.40.206.0 to 220.127.116.11.0 [Release 2.2 to 2.3]
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