Re: Windows freezing during SQL*PLUS execution.

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 Received on Sat Jul 29 1995 - 00:00:00 CEST