Re: Significant difference in response times for same query running on Windows client vs database server

On Thursday, January 30, 2014 11:15:20 AM UTC+11, mjm..._at_gmail.com wrote:

> Are there are configuration changes that can be done on the Oracle client or database to improve the response times for the query when it is running from the client?

I don't think you are after an improvement in response time. Rather a marked improvement in total runtime.

Don't know what product you're using on the client. SQL*Plus or similar?
If so, look into "array size".
As well, you may need slightly different TNS parameters for the connection. But the first cab off the rack is to increase the size of the array. Which basically defines how many result rows come across for every interaction between the client and the db server. Here:
http://docs.oracle.com/cd/E11882_01/server.112/e16604/ch_eight.htm#sthref927

There are a few other points raised by your message but I won't go into them now. Received on Thu Jan 30 2014 - 04:58:14 CET