Re: SQL*NET 2.1 TCP/IP Aysnc I/O?
Date: 1995/09/16
Message-ID: <43dv26$5an_at_inet-nntp-gw-1.us.oracle.com>#1/1
In article <42kih1$f14_at_explorer.csc.com> Charles Walker <cwalker_at_explorer.csc.com> writes:
> Oracle says that SQL*NET 2.1 will run in Aysnc mode. I am running 2.1 on
> a Windows client and when ever a query is sent it still locks up my PC
> until the results are returned. I thought 2.1 would allow async I/O so I
> could go and do other work? I am I wrong?
Technically we're talking about blocking vs. non-blocking mode.
Non-blocking example:
You start a query via SQLPlus on your SQL*Net v2 TCP/IP client for Windows and
while the query is running, you use another application to do something else on
your PC.
Starting with SQL*Net v2.1.4, SQL*Net has the non-blocking feature you're talking about.
However, you need the non-blocking feature built into every Oracle layer.
Including:
RDBMS (v7.1.4 and above)
SQL*Net (v2.1.4 and above)
UPI (Oracle Interface for Oracle Tools)
OCI (Oracle Interface for Third Party Tools)
If you don't have the non-blocking feature built into everything, you won't get non-blocking at all. An undocumented feature of Browser v2.0 is that it's UPI layer has the non-blocking feature, so you'll get non-blocking mode if you use it with at least SQL*Net v2.1.4 and RDBMS v7.1.4.
Third party tools need to be recompiled with the OCI that includes the non-blocking feature to take advantage of it.
g
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% Oracle Networking Support % guru dude, joe SQL*Net, joe SQL*Toes %
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%Received on Sat Sep 16 1995 - 00:00:00 CEST