We have built a batch process using DOA. This process takes approximately one hour to run. The application is read only and creates a very large text file. This process sometimes suspends indefinitely (the problem is intermitent). When we look at this session on the Oracle Database side we see the session waiting for the client to respond at the SQL Net layer. The message is: "Waiting for SQL*Net message from client driver id=675562835 #bytes=1".

Has anyone seen this? Are there important SQL*Net settings on the client side to modify?

It appears as though the client and server are loosing track of one another at the SQL Net layer. This problem seems to be DOA related.

Please Help!