cdshrewd

每个人都是一个矛盾体,正能量和阴暗面从来都是共生的

IPC issue

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. 

So from these explanation, it's very clear for those applications:
which are running on the same box with its corresponding Database. From Performance perspective, it is good since it will save "overhead of packet building and deciphering" that TCP has. 

I've used these in several big Telcom projects in the world. 

For how to configure it:
1. you should add one IPC line in the LISTENER.ORA
2. You should also add one IPC line in the TNSNAMES.ORA

评论