Poor Performance on Queries Against AMR_METER_REQ_STATUS_VIEW
(Doc ID 2882571.1)
Last updated on JULY 12, 2022
Applies to:
Oracle Utilities Network Management System - Version 2.3.0.2.0 to 2.5.0.2.0 [Release 2.3 to 2.5] Oracle Network Management for Utilities - DMS - Version 2.5.0.2.0 to 2.5.0.2.0 [Release 2.5] Information in this document applies to any platform.
Symptoms
On : 2.3.0.2.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.
Changes
Cause
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
