Oracle Wire Protocol

[Shivkumar]

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

[Chan 007]

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

[Indira Aramandla · Accepted solution]

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

[Arunvijai_4]

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

[Steven E. Protter]

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

[Arunvijai_4]

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

[Shivkumar]

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

[Yogeeraj_1]

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