My Oracle Support Banner

Slow Query in GElectic Extractor’s Change Detect (Doc ID 2630315.1)

Last updated on JANUARY 22, 2020

Applies to:

Oracle Utilities Network Management System - Version 2.3.0.2.0 and later
Oracle Network Management for Utilities - DMS - Version 2.3.0.2.0 and later
Information in this document applies to any platform.

Goal

 


It seems like this AND condition of the GIS change detect query takes up a lot of time:
(FID_GEAR_NMS.CONNECTIVITY_N.Circuit1 IS NOT NULL OR FID_GEAR_NMS.CONNECTIVITY_N.Circuit2 IS NOT NULL).

Is this check required or can it be removed?
 

Solution

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
Goal
Solution


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