IPC Vs TCP for DBLink

Printable View

06-04-2004, 10:22 AM
Jr

IPC Vs TCP for DBLink

Hi,
I guess , Gurus up here did gone thru this...,
and would like to learn their bullet points .

What is the performance difference,
when dblink refers with following protocols mix-match.
( Assuming all instances on the same server ).

1) IPC <-> IPC
2) IPC <-> TCP
3) TCP <-> TCP

Thanks in advance.
Jr.
06-04-2004, 10:25 AM
abhaysk

Can you achieve first option with DB Links? -- Well i dont think so
06-04-2004, 10:29 AM
Jr

Yes , We can !!!
06-05-2004, 02:24 AM
abhaysk

Well if you give connect string while connecting to a DB then Oracle/OS is bound to use TCP.. Aint it?

If so how can u achieve your first option?
06-06-2004, 04:18 PM
jmodic

Quote:

Originally posted by abhaysk
Well if you give connect string while connecting to a DB then Oracle/OS is bound to use TCP.. Aint it?

Why do you think that Oracle can only use TCP protocol?
06-07-2004, 03:27 AM
abhaysk

Quote:

Originally posted by jmodic
Why do you think that Oracle can only use TCP protocol?

Well logically it should be TCP.. Because if you give connect string oracle is bound to search for the listener on the HOST.. And in Listener.Ora you would have mentioned

Code:

(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Hostname)(PORT = 1521)) )
06-07-2004, 03:54 AM
jmodic

Code:

(ADDRESS_LIST = (ADDRESS = (PROTOCOL = nmp)(SERVER=my_server)(PIPE=my_pipe)) )
06-07-2004, 04:04 AM
abhaysk

Quote:

Originally posted by jmodic

Code:

(ADDRESS_LIST = (ADDRESS = (PROTOCOL = nmp)(SERVER=my_server)(PIPE=my_pipe)) )

Thas fine but here it was IPC vs TCP.. can you use IPC if there is connect string specified from client/server?
06-07-2004, 04:35 AM
jmodic

Quote:

Originally posted by abhaysk
Thas fine but here it was IPC vs TCP..

Right. But you said "... if you give connect string while connecting to a DB then Oracle/OS is bound to use TCP", which certanly is not true, regardles of the initial question.

Nevertheless, if you want to stick with the original question, how about:

Code:

(ADDRESS = (PROTOCOL = IPC)(KEY = MY_IPC))

Why do you think this wouldn't work with the databse links? Original poster explicitely mentioned all instances to be addressed via db links are on the same server, so what's wrong with using IPC for db links?
06-07-2004, 04:44 AM
hrishy

Hi Jurij

will your stuff work..i was under the impression that IPC cannot work over network say from machine A to machine B it works only on a single machine..

regards
Hrishy
06-07-2004, 04:52 AM
jmodic

Quote:

Originally posted by hrishy
Hi Jurij

will your stuff work..i was under the impression that IPC cannot work over network say from machine A to machine B it works only on a single machine..

Exactly! But if you look at the original question, you'll find the following:

Quote:

Originally posted by Jr
... ( Assuming all instances on the same server ).

So all the involved databases reside in one single computer, hence they can comunicate with each other using IPC, no?
06-07-2004, 05:19 AM
hrishy

Hi Jurij

Yup ur right..with single instance that works..sorry my oversight..

regards
Hrishy
06-07-2004, 07:21 AM
abhaysk

Quote:

Originally posted by jmodic

Code:

(ADDRESS = (PROTOCOL = IPC)(KEY = MY_IPC))

Why do you think this wouldn't work with the databse links? Original poster explicitely mentioned all instances to be addressed via db links are on the same server, so what's wrong with using IPC for db links?

Oh yeah I tried that.. however i noticed the information in connect info dynamic view & it says its using Named Pipes..

But if you connect without any connect string it uses Bequeath (Aka IPC internally)..

So was kind of confused if it really uses IPC when Connect String is given ( Coz Dynamic View says its connected via "Windows NT Named Pipes NT Protocol Adapter for 32-bit Windows: Version 9.2.0.1.0 - Production" )

Abhay.
06-07-2004, 04:23 PM
Axr2

Jr's initial question about how different protocols affect performance appears to be unanswered. Would be good if someone could shed some light.
06-08-2004, 02:56 AM
hrishy

Hi

I dont think so performance would very much..i tested this on newer versions of hp-unix and windows Nt sp6 and above..the kernel was smart enough not to route this packest through the network interface when using IPC and Named pipes..i beleive he will ahve similar results with linux and other OS es..

regards
Hrishy
06-09-2004, 03:19 AM
abhaysk

Quote:

Originally posted by hrishy
the kernel was smart enough not to route this packest through the network interface when using IPC and Named pipes..i beleive he will ahve similar results with linux and other OS es..

Even if its TCP it wont route to N/W ( except an initial dummy packet i guess ).. So performace wise it would be hardly any difference.. (Except for a duration when OS has to decide whether it needs to route data to N/W in case of TCP)..