My Oracle Support Banner

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 to [Release 2.3 to 2.5]
Oracle Network Management for Utilities - DMS - Version to [Release 2.5]
Information in this document applies to any platform.


On : 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!

In this Document
 Fix Description

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.