Re: If you have a databaselink to a databae in the same server you should be using ipc
- From: "Juan Carlos Reyes Pacheco" <jreyes@xxxxxxxxxxxxxxxx>
- To: <sol.beach@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 5 Oct 2004 17:25:33 -0400
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@xxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxx> 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
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
