strange intermittent hangs (10-20s) Oracle 8.1.7 Win32

hello,
i have a problem with an Oracle Server 8.1.7.0.0 (!)

the database is frequently accessed by a process (via ODBC) that executes small SQL orders (select by pk or unique index) and single line updates/deletes.

all these sql orders perform generally very fast (milliseconds) but on this server, frequently, some orders perform in about 10-20 seconds

Symptoms (i cannot be SYS on this server to run oradebug / tkprof) :
- during the "freeze", ODBC process consumes 0% cpu, as Oracle.exe process

• no disk Writes on these process (except Oracle that writes some blocks regularly)
• no disk Reads
• no network packet exchanged

i ran some scripts (locks, waiting sessions etc..) and some tools (sysinternals filemon, diskmon ...) but i see nothing that can explain this freeze

the strange thing is that, when it freezes, the execution of a "select 1 from dual" on an sqlplus session make it restart immediatly (i can reproduce this 100%)

Win32 network issue maybe ?
uh... server is Windows 2003 SP1 on 32bit Intel (i know it is not supported!)

any idea welcome !
Christian Received on Wed Sep 20 2006 - 12:07:00 CDT