Windows freezing during SQL*PLUS execution.
Date: 1995/07/27
Message-ID: <3v8mkt$ba6_at_helios.vanderbilt.edu>#1/1
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