Re: SQL*Net 2.2, Asynchronous

SQL*Netters:

I did some in-depth investigation on the whole issue of asynchronous/non-blocking queries. According to Matthew Shore of the Networking group (he was the only person at Oracle that REALLY knew anything about this subject), Oracle provides certain levels of support for non-blocking queries:

• UPI Level: RDBMS 7.1.4 with SQL*Net 2.1.4
• OCI Level (3rd party tools): RDBMS 7.2 with SQL*Net 2.2

Here's the rub. Although 7.2 with 2.2 is shipping with MOST platforms, the 3rd party vendors needed to do the following:

• Significantly re-write their application using explicit non-blocking OCI calls.
• Compile and relink their applications with the OCI 7.2. The libraries are located in $ORACLE_HOME/LIB

I'm familiar with this subject because I coordinated this information between our organization and Brio Corp, a software vendor (BrioQuery) that makes a popular Q&R tool for Windows and Macintosh. However, as of August 23rd, OCI 7.2 was not even shipping?! Obviously the pieces of an Oracle release are not ready at the same time. In addition, we had a tough time even getting hold of the SQL*Net 2.2 for Windows.

Don't expect the non-Oracle tools that you're using to immediately be non-blocking for some time unless the software company got pre-release betas.

When the "non-blocking wars" are finally fought and won I'm sure that there will be a lot of satisfied query and reporting end-users who don't have their workstations locked up on long queries.

Hope this information helps anyone out there interested in this subject.

Rick Ellison
The DBA Guy

In article <42ks6g$eve_at_ixnews3.ix.netcom.com>,

   chuckh_at_ix.netcom.com (Chuck Hamilton) wrote:
>Charles Walker <cwalker_at_explorer.csc.com> wrote:
>
>>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?
>
>The client application has to be written to run async. too. Most are
>not. So far the only app I've gotten run async is Oracle Data Browser.
>And only if the underlying transport protocol is TCP/IP.
Received on Wed Sep 06 1995 - 00:00:00 CEST