Activity Hierarchy In MDM Have Some Performance Issues
(Doc ID 2761595.1)
Last updated on MAY 31, 2024
Applies to:
Oracle Utilities Meter Data Management - Version 2.2.0.2.0 to 2.3.0.2.0 [Release 2.2 to 2.3]Information in this document applies to any platform.
Symptoms
On Oracle Utilities Meter Data Management 2.3.0.2.0 version, Performance / Database
ACTUAL BEHAVIOR
---------------
This occurs on MDM v2.3.0.2.0 (upgrade project) and MDM v2.1.0.3.0.
When a user attempts to open an activity that has communication IDs linked to it, it takes more than 15 seconds for the activity hierarchy zone to load.
EXPECTED BEHAVIOR
-----------------------
It is expected that this zone load within milliseconds.
WORK AROUND
-----------------------
A custom index was added:
create index CISADM.CM_IDXINCOMMID on CISADM.D1_COMPL_EVT("IN_COMM_ID");
This will reduce the cost to < 100 which makes the activity hierarchy to load at milliseconds.
The table is partitioned and the added index is a global index so this might lead to issues in the long run thus requesting a permanent solution.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. In MDM UI, go to Activity Query and enter terms for search
2. Select an Activity
3. Activity screen loads but the Activity Hierarchy is taking 15 seconds to load
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! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |