is IPC really faster than TCPIP?

From: Juan Carlos Reyes Pacheco <jreyes_at_dazasoftware.com>
Date: Wed, 1 Sep 2004 17:24:14 -0400
Message-Id: <41363DFE.000003.06428@DAZA-MGEJCA5J7T>

Hi list, Sorry for starting two thread about the same, but I found

Tom Kyte says "well, tuning TCP vs IPC would give you marginal improvements.

http://asktom.oracle
com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:6136118136754

but Kenny Smith in Use IPC for local connections, a process can be up to 10x faster
he says " I've seen a SQL job that runs in 10 minutes using TCP on a local machine run as fast as one minute using an IPC connection" But http://searchoracle.techtarget.com/originalContent/0,289142 sid41_gci940662,00.html

So I think the question is not is why ipc is not faster, else is IPC really faster.
Some experiences please.

Juan Carlos Reyes Pacheco
OCP

To unsubscribe send an email to: oracle-l-request_at_freelists.org and put 'unsubscribe' in the subject line.

Received on Wed Sep 01 2004 - 21:44:02 CDT