Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: If you have a databaselink to a databae in the same server you should be using ipc

Re: If you have a databaselink to a databae in the same server you should be using ipc

From: Yechiel Adar <adar76_at_inter.net.il>
Date: Sun, 10 Oct 2004 20:09:47 +0200
Message-ID: <096f01c4aef4$55999bc0$c701a8c0@sys3>


I think that you should not use IPC across database links. In two years time the load will increase and some dba will decide to move one database to another machine and then the link will not work and nobody will remember that it use IPC and now needs to be converted to tcp/ip.

Yechiel Adar
Mehish
----- Original Message -----
From: "Juan Carlos Reyes Pacheco" <jreyes_at_dazasoftware.com> To: <sol.beach_at_gmail.com>; <oracle-l_at_freelists.org> Sent: Tuesday, October 05, 2004 11:25 PM Subject: Re: If you have a databaselink to a databae in the same server you should be using ipc

> Hi,
> Exactly how do you change it fron the source DB to the target DB?
> I think this answer your question
>
> fROM http://searchoracle.techtarget.com/originalContent/0,289142
> sid41_gci940662,00.html
> When a process is on the same machine as the server, use the IPC protocol
> for connectivity instead of TCP. Inner Process Communication on the same
> machine does not have the overhead of packet building and deciphering that
> TCP has. 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. The difference
in
> time is most dramatic when the Oracle process has to send and/or receive
> large amounts of data to and from the database. For example, a SQL*Plus
> connection that counts the number of rows of some tables will run about
the
> same amount of time, whether the database connection is made via IPC or
TCP.
> But if the SQL*Plus connection spools much data to a file, the IPC
> connection will often be much faster -- depending on the data transmitted
> and the machine workload on the TCP stack.
>
> You can set up your tnsnames file like this on a local machine so that
local
> connection with use IPC connections first and then TCP connection second.
>
> PROD =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(Key = IPCKEY))
> (ADDRESS = (PROTOCOL = TCP)(HOST = MYHOST)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SID = PROD)
> )
> )
>
> To see if the connections are being made via IPC or TCP, turn on listener
> logging and review the listener log file.
>
>
> I only ask if someone has something against doing this when using database
> links?
>
> Juan Carlos Reyes Pacheco
> OCP
> -------Original Message-------
>
> From: sol beach
> Date: 10/05/04 17:09:28
> To: jreyes_at_dazasoftware.com
> Subject: Re: If you have a databaselink to a databae in the same server
you
> should be using ipc
>
> IPC depends upon the value of ORACLE_SID. Right?
> Exactly how do you change it fron the source DB to the target DB?
>
> Ready, Fire, Aim!
>
>
> On Tue, 5 Oct 2004 16:59:22 -0400, Juan Carlos Reyes Pacheco
> <jreyes_at_dazasoftware.com> wrote:
> > Hi, one question please, if you have some comment about this.
> >
> > I think if you have a databaselink to a database in the same server you
> > should be using ipc conection or
> > there is something saying it is not advisable
> >
> > Thanks in advance.
> >
> > Juan Carlos Reyes Pacheco
> > OCP
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> --
> http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l
Received on Sun Oct 10 2004 - 12:15:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US