PERFORMANCE PROBLEM ON OBJECTEL DATABASE, TABLE IMCONNECTION (Doc ID 972769.1)

Last updated on APRIL 27, 2021

Applies to:

Symptoms

-- Problem Statement:

Below Select statement on IMCONNECTION, ASSOCIATION and on Customized table (OBJ_FacVLan) is taking almost 6-9 seconds to execute at Customer Production Environment.

Select imConnection.objectID,imConnection.typeID,imConnection.inProjectID,imConnection.inProjectType ,imConnection.outProjectID,imConnection.outProjectType,imConnection.aSiteID,imConnection.aSiteType,imConnection.aNetworkElementID,imConnection.aNetworkElementType,imConnection.aPortID,imConnection.aPortType,imConnection.aChannelPath,imConnection.zSiteID,imConnection.zSiteType,imConnection.zNetworkElementID,imConnection.zNetworkElementType,imConnection.zPortID,imConnection.zPortType,imConnection.zChannelPath,imConnection.flowQualityCode,imConnection.capacityUsed,imConnection.percentUsed,imConnection.maxCapacity,imConnection.warningThreshold,imConnection.consumedSignalType,imConnection.signalType,imConnection.resourceState,imConnection.effectiveFrom,imConnection.effectiveTo,imConnection.channelized,imConnection.circuitUsage,imConnection.visualKey,OBJ_FacVLan.FACClassService,OBJ_FacVLan.FACBandwidth,OBJ_FacVLan.FACVLANID,OBJ_FacVLan.FACIPSUBNETLABEL,OBJ_FacVLan.FACBRASPORT,OBJ_FacVLan.FACBRASVLAN,OBJ_FacVLan.FACServiceProfile,OBJ_FacVLan.FACStatus,OBJ_FacVLan.GRLNotes,OBJ_FacVLan.AG2CreatedBy,OBJ_FacVLan.AG2CreatedDate,OBJ_FacVLan.LastUpdatedBy,imConnection.LastUpdatedDate,imConnection.LastReconciledDate,OBJ_FacVLan.FACVLANALIAS,OBJ_FacVLan.UploadBandwidth,OBJ_FacVLan.ServiceType,OBJ_FacVLan.FACSpectrum from Association,imConnection,OBJ_FacVLan where imConnection.objectID=OBJ_FacVLan.sysObjectID and Association.ObjectID = :1 and Association.AssocIdentifier = :2 and Association.ObjectTypeCode = :3 and Association.AssociationStatus != :4 and Association.AssocTypeCode = :5 and to_number(imConnection.objectID)=rtrim(Association.AssocKey1);

Changes

Cause

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