Re: If you have a databaselink to a databae in the same server you should be using ipc
- From: Carel-Jan Engel <cjpengel.dbalert@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 11 Oct 2004 19:13:23 +0200
The first time I read this comment I was simply too flabbergasted to
react. Thank you Jared.
If you want to suffer from bad performance due to totally unnecessary
routing of your local traffic through your network stack, be my guest.
What you are describing is a new DBA who is unaware of configuration
issues of e.g. Oracle Net. Probably he isn't even a new DBA. When we are
going to defend all our stuff against the ignorants that MAY be our
successors, you'd better start documenting your work in a proper way.
Dependencies between systems is about the first thing one should know
of, and not only because of database links.
Maybe developers should quit Java immediately (and 'C', and Cobol, maybe
even basic) because their successors probably cannot understand the
programming language in use today. Jared, please don't use Perl. I'm a
ksh man, and maybe I cannot understand your work when I get into the
position to be your successor somewhere.
;-)
Sorry Yechiel, but I have no other option than to fully disagree with
you.
Best regards,
Carel-Jan Engel
===
If you think education is expensive, try ignorance. (Derek Bok)
===
On Mon, 2004-10-11 at 19:24, Yechiel Adar wrote:
> Just to clarify:
> I meant that in two or three years you are working in another company and a
> new body is doing the dba work. When the time comes to move the database to
> another server he will just install oracle, copy the database files and
> tnsnames to the new server and will be sure that it will work. When he will
> start to get errors he will spend time trying to find why the same database
> with the same tnsnames that worked on the other server fails now.
>
> Yechiel Adar
> Mehish
> ----- Original Message -----
> From: "Yechiel Adar" <adar76@xxxxxxxxxxxx>
> To: <oracle-l@xxxxxxxxxxxxx>
> Sent: Sunday, October 10, 2004 8:09 PM
> Subject: Re: If you have a databaselink to a databae in the same server you
> should be using ipc
>
>
> > 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@xxxxxxxxxxxxxxxx>
> > To: <sol.beach@xxxxxxxxx>; <oracle-l@xxxxxxxxxxxxx>
> > 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@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
> >
> > --
> > //www.freelists.org/webpage/oracle-l
>
> --
> //www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
