IPC slower in local connection

From: Juan Carlos Reyes Pacheco <jreyes_at_dazasoftware.com>
Date: Wed, 1 Sep 2004 16:41:46 -0400
Message-Id: <4136340A.000003.01564@DAZA-MGEJCA5J7T>

Hi does any one please has experience or understand the internal processing of IPC connections.
When is IPC faster, I read IPC can be up to 10 times faster but in the test is almost equal or less than tcpip connection. Can some one can explain which process benefits from IPC. Thanks  

I did a test five times
and ipc got 3917,2589, 2537,2618,2515 and tcpip got 2507,2513,2448,2504,2493

This is my configuration
tnsnames.ora
ORCL.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.77)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORCL)

)
)  

ORCLIPC.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(Key = IPCKEY))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORCL)

)
)
listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\product\10.1.0\Db_1)
(PROGRAM = extproc)

)
)  

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = IPCKEY))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = daza-mgejca5j7t)(PORT = 1521))
)
)  

This is the test code
declare
n1 number;
n2 number;
begin
n1 := dbms_utility.get_time;
for b in ( select * from dba_objects, (select dummy from dual union all select dummy from dual) b) loop
insert into dba_objects2(OWNER, OBJECT_NAME, SUBOBJECT_NAME, OBJECT_ID, DATA_OBJECT_ID, OBJECT_TYPE, CREATED, LAST_DDL_TIME, TIMESTAMP,
STATUS, TEMPORARY, GENERATED,
SECONDARY
) values(b.OWNER, b.OBJECT_NAME, b.SUBOBJECT_NAME,

b.OBJECT_ID, b.DATA_OBJECT_ID, b.OBJECT_TYPE, 
b.CREATED, b.LAST_DDL_TIME, b.TIMESTAMP, 
b.STATUS, b.TEMPORARY, b.GENERATED, 
b.SECONDARY) ;

end loop;
n2 := dbms_utility.get_time;
rollback;
dbms_output.put_line( n2-n1 );
end;
/  

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:56:36 CDT