I am aware that this is not a question for Toad, maybe more a client thing, but still… here is the problem:
I recently changed server for our hosted Oracle DB server. The new database server have 8 cores, 16 GB RAM, runs on Windows 2003R2 64bit with Oracle 64-bit 10.2.0.3.0. Everything is lightning-fast on this new server. Running scripts is just breathtaking.
Then I have an import/export server that I have also installed Toad on.
Server is Windows 2008R2 64-bit with 8 cores and 16 GB RAM. I have installed 32-bit Oracle client on that one, because I (maybe mistakenly) read somewhere that Toad need 32-bit.
I then installed Toad V10.6.
My problem now is that although Toad works, running scripts is so painfully slow that I generally give up. If a script has been lingering on for 20 minutes, I stop it and run it directly on server and it takes maybe 5 seconds!
Obviously something is wrong. Also running things on the client machine in sqlplus is slow, so it is not Toad that is the problem.
Can this be because I am running a 32-bit Oracle client on a 64-bit OS that talks to a 64-bit Oracle? Should I try to install 64-bit Oracle client? Will Toad 10.6 still work?
If this has nothing to do with it, what can I check on client machine as well as on Oracle server to get the speed up? Remember that I am not talking about small differences, I am talking about scripts can be executed on server in 5 seconds, that on the client server takes 20 minutes. The servers are in the same subnet and have gigabit connection between them.
Any hints on how to fix this would be fantastic, thanks!