topic Re: Oracle Wire Protocol in Operating System - HP-UX

Oracle Wire Protocol

Shivkumar — Tue, 31 Jan 2006 19:04:54 GMT

what is the use of wire protocol ? Does it run over tcp/ip ?

Re: Oracle Wire Protocol

Chan 007 — Tue, 31 Jan 2006 19:10:53 GMT

I seen web based programmers used to tell SAs this thing.

Yes u r right, it binds to the TCP/IP suite
via http.

For more details

http://java.sun.com/j2se/1.4.2/docs/guide/jpda/jdwp-spec.html

Chan

Re: Oracle Wire Protocol

Indira Aramandla — Tue, 31 Jan 2006 20:02:30 GMT

Hi Shivkumar,

A DBMS is written using an application programming interface (API), which is specific to that database. For example, an Oracle 9i database has its own version of the API specification (called Net9), which must run on each client application.

Developers write applications compliant to the ODBC specification and use ODBC drivers to access the database. The ODBC driver communicates with the vendor's native API. Then, the native API passes instructions to another vendor-specific low-level API. Finally the wire protocol API communicates with the database

The wire protocol architecture eliminates the need for the database's native API (for example, Net9), so the driver communicates directly to the database through the database's own wire level protocol. This effectively removes an entire communication layer

Indira A

Re: Oracle Wire Protocol

Arunvijai_4 — Tue, 31 Jan 2006 23:13:23 GMT

Hi Shiv,

Some links that should shed light for you,

http://media.datadirect.com/download/docs/odbc/odbcref/oracle.html
http://forums.datadirect.com/ddforums/thread.jspa?messageID=3663

-Arun

Re: Oracle Wire Protocol

Steven E. Protter — Wed, 01 Feb 2006 05:11:55 GMT

Shalom Shiv,

The articles above define this as ODBC access. This is the least desireable of the possible Oracle access methods. ODBC is more likely to have support and performance issues than oracle client for example.

Yes, it runs TCP/IP.

SEP

Re: Oracle Wire Protocol

Arunvijai_4 — Wed, 01 Feb 2006 05:54:12 GMT

Hi Shiv,

SOAP is also a wire protocol like IIOP for CORBA, ORPC for DCOM, or Java Remote Method Protocol (JRMP) for Java Remote Method Invocation (RMI). I think, Oracle uses SOAP and XML in 9i. It runs on TCP/IP Layer.

http://www.javaworld.com/javaworld/jw-03-2001/jw-0330-soap.html

-Arun

Re: Oracle Wire Protocol

Shivkumar — Wed, 01 Feb 2006 13:49:40 GMT

What is the word "wire" stands for with respect to this technologies ? Thanks.

Re: Oracle Wire Protocol

Yogeeraj_1 — Thu, 02 Feb 2006 02:25:13 GMT

hi shiv,

In fact, Wire refers to the IP protocol.

When referring to data path over WAN, IP, the protocol that is actually on the wire, does not care which path the PDU takes, nor does it care what order the PDUs arrive. With multiple paths to it's destination, a TCP/IP "conversation" may use all the paths at once,
and the client will have to reassemble that "conversation." This will add to the delay.

the above is an extract from metalink note:
Note:1005123.6 - Tuning SQL*Net for better performance

hope this helps!

kind regards
yogeeraj