AnsweredAssumed Answered

ARCGIS 10.3.1 AND Oracle 11g SLOW CONNECTION ISSUES

Question asked by prabusankar_s on May 1, 2018
Latest reply on May 2, 2018 by vangelo-esristaff

Hi,

 

We have been using ArcGIS Desktop and Oracle 11g for many years. A year ago we migrated from ArcGIS 9.3.1 to ArcGIS 10.3.1 moving away from SDE schema to user based geodatabase schema. Recently our users are complaining on the slowness in the connection. In which we noticed that the connection to Oracle drastically slowed to beyond 30 seconds additionally refresh connection and expand connection takes the time to unprecedented 6 minutes. We have over 2000 featureclasses but this was not a problem in ArcGIS 9.3.1.  What could be the issue?

 

Have been through forums and found a bug relatively similar as in the following link

ARCGIS 10.3.1 AND SQL SERVER 2014 SLOW CONNECTION ISSUES 

 

Related Bug accepted in ESRI

Bug BUG-000081116:Optimize the TableListTables command or query involved in enterprise database connections.

 

Is this the bug related to my issue. Can someone help to guide us? 

 

Thanks

 

Regards

Prabu

Outcomes