ORACLE 19c query Performance disparity client and server
October 28, 2020 - 8:55 am UTC
Reviewer: Que Bonito from Zurich, Switzerland
Many thanks for your fast reply.
After setting the fetch size to 200 the query on the win 10 client takes now 111 secs compared to 166 secs with the fetch size default of 50. The performance on the server is the same, very fast with 2 to 3 secs.
As the .net application peforming the query is not acccessing via sql developer i was wondering what this setting would help ? Or do you just want to see with that approach whether there might be network issues? Ok then this is my review and I look forward to your next recommended steps. Cheers from Switzerland
October 29, 2020 - 2:45 am UTC
OK, next step would be enable a trace for both operations (server and client)
- exec dbms_monitor.session_trace_enable(waits=>true)
- run query
You will get a trace file for each. Run them through tkprof and we'll get a better idea of where the time is lost.