Anyone can share the tips or solution for the slow connection from ArcGIS 10.3.1 and ArcGIS 10.5.1 after Geodatabase has been upgraded from SDE 10.1 to 10.2.2 then 10.3.1 ? The Oracle version has been upgraded from 22.214.171.124 to 126.96.36.199.
I had done several tuning on Oracle side including increasing SGA size , PGA size and also some Oracle parameters but still no help. I have also even run the following work around to add "open_cursor" parameter in server_config table, not really help either.
Greatly appreciated your help ..
I have attached the trace file FYI..