Networks

Ask something
Discussion Locked

Oracle Client Slowness

0 helpful
1 reply

by sphoran

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
We are running multiple client/server applications using oracle 8.1.7 server and client. All of our pc's seem to slow down dramatically once the client has been installed. Is anyone aware of any tweaks that can be done on the client side that would help improve this.

1 reply

by rrv

Check if all services running are 32 bit versions. Check if pooling is started in ODBC manager. enable trace utility in ODBC manager and investigate. Check if the client applications are closing the connection objects are calling the destructor every time. This will definitely make pc slower. if pooling is started the connection objects are not to be destroyed. they are only to be closed. ex. ConDB.close is enough. the line set ConDB=nothing in VB will take lots of resources to cleanup and start again.

This discussion is closed to new replies.