Re: Windows freezing during SQL*PLUS execution.
Date: 1995/08/02
Message-ID: <3vmgsp$crm_at_ixnews5.ix.netcom.com>#1/1
Jim Winterroth <jwinter_at_qdrs2a.stg.trw.com> wrote:
>Randy Fought <FOUGHTRL_at_CTRVAX.VANDERBILT.EDU> wrote:
>>
>> When performing data manipulation operations from a client
>> Windows i486 machine using SQL*PLUS the client machine gets
>> locked up (no other work can be done on the client, can't even
>> ALT-TAB to program manager).
>> This occurs on long updates, alter tables (adding
>> primary keys, enabling foreign keys, etc). All the work is being
>> done on the server - no traffic at all over SQL*NET other than
>> the SQL code.
>> I know Windows (in this case Windows for Workgroups) is
>> not a very good multi-tasking OS but this is ridiculous. Or, has
>> Oracle written bad code that doesn't return control back to windows
>> while the server machine does its task?
>> Anybody have the same problem. Is there a system setting of
>> some kind on the client to alleviate this problem?
>> Thanks in advance - Randy Fought
>I'm on a Dell 586/90 16Mb RAM and have the same problem. I can have
>ftp or Netscape retrieve large files while I switch to Word so I'm
>guessing it's Oracle code. I get frustrated enough trying to get Oracle
>Support to help with serious problems so I haven't even asked them this.
>Jim
It's Oracle's lousy code.
SQL*Net 2.1 is the culprit. It only works non-blocking (asynch.) under the following conditions...
- The network protocol must be TCP/IP.
- The TCP/IP stack must support asynchronous operation
- The client program must be Oracle Data Browser! No others!
IMHO this is inexcusable. Nobody's written blocking Windows code since prior to version 3.1, at least 3 years ago.
I'm running into the same problem with a data warehouse project I'm currently working on and this "glitch" is jeopordizing the whole project. We don't want to use Browser because it doesn't come anywhere near the robustness of at least a dozen other DSS products out on the market. We were told back in January when we selected Oracle as the database that they already had non-blocking SQL*Net. It's now August 1st and they still don't!
Maybe this is Oracle's way of selling copies of Browser. Whether it is or isn't, I'm very disappointed to say the least. Received on Wed Aug 02 1995 - 00:00:00 CEST