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
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?