Preemptive Multitasking for Windows Clients via SQL*Net V1.X
From: Michael Stowe <Michael.Stowe_at_f573.n115.z1.fidonet.org>
Date: Fri, 04 Nov 94 09:33:12 -0600
Message-ID: <783941593_at_f573.n115.z1.ftn>
Date: Fri, 04 Nov 94 09:33:12 -0600
Message-ID: <783941593_at_f573.n115.z1.ftn>
- Quoting Wong_at_Interlog.Com to All dated 11-01-94 ***
> Does anyone know in SQL*Net v1.x if there is a way to eliminate the
> Windows lockup when a long query or stored procedure is executed from a
> Windows client applications against an Oracle RDBMS?
Windows is not a pre-emptive multitasking platform, as you have already mentioned, so don't expect miracles. But that is really only part of the issue -- SQL*Net is synchronous, which means that it must wait for a reply from the server (on any platform) so the current application will not be able to process anything else, anyway.
The basic "lockup" you experience under Windows is because the Windows message queue is not being polled; to prevent it, Oracle would have to a) use asynchronous SQL*Net and b) poll the message queue while SQL*Net is waiting for a reply. Received on Fri Nov 04 1994 - 16:33:12 CET