Slowdown/timeout with JDBC Oracle thin drivers

I saw a report of this earlier on an Oracle message board, but no resolution.

I'm using Oracle 8.1.6 on Win NT, with Oracle thin driver 8.1.6.2.0.

The symptom is that occasionally a JDBC call (particularly createStatement)
will take ~60 seconds to return - no error, but a long time to return. Frequently while I'm waiting for 60 seconds, if I start another copy of my test program (making the same query to the same database), that seems to kick things loose, and the original hung call will complete immediately.

I see this only on one out of four machines I have set up (not quite identically, but as close as I can get). Of course, it's the one machine that's getting real live users.

Anybody else seen this/have any suggestions?

Ron Scott
rscott_at_visi.com Received on Thu Nov 02 2000 - 23:09:56 CST