On thing that might help you diagnose the problem is a free tool called
sql monitor. It works by trapping all the communication made between a
specific client app and the oracle client, it outputs all the sql
statements, error messages, connects, disconnects and so on. I strongly
suggest using that to see if the .net portion is constatnly connecting,
disconnecting. or if there is a huge amount of time between insert
requests.
go here: http://www.toadsoft.com/downld.html and download SQL Monitor.
Received on Thu Jun 02 2005 - 16:16:25 CDT
