Poor Performance on Queries Against AMR_METER_REQ_STATUS_VIEW
(Doc ID 2882571.1)
Last updated on JULY 12, 2022
Oracle Utilities Network Management System - Version 18.104.22.168.0 to 22.214.171.124.0 [Release 2.3 to 2.5] Oracle Network Management for Utilities - DMS - Version 126.96.36.199.0 to 188.8.131.52.0 [Release 2.5] Information in this document applies to any platform.
On : 184.108.40.206.0 version, Web Workspace
During performance testing, opening the "AMI Customers List..." tab in Trouble Info was taking several minutes. AMI Customers table in Trouble Info is populated in timely manner.
The issue can be reproduced at will with the following steps:
1. Open Viewer and select a device with large number of connected AMI-enabled customers. 2. Open Control Tool and select "AMI Customer List..." option.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!