Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Bequeath vs. TNS connections
I have been doing some speed comparisons between using the bequeath and
TCP methods of connecting to a local 8.1.7 database (SuSE Linux) and
found the TCP method faster! This is the opposite of what I would have
thought to be the case since BEQ doesn't involve a roundtrip to the
network card.
I did my measurements using the tnsping utility and here are the results:
% tnsping rsm_beq 10
...
Attempting to contact
(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleRSMi)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))
OK (20 msec) OK (10 msec) OK (20 msec) OK (20 msec) OK (20 msec) OK (20 msec) OK (10 msec) OK (20 msec) OK (20 msec) OK (20 msec)
% tnsping rsm 10
...
Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=krass)(PORT=1521))
OK (0 msec) OK (10 msec) OK (0 msec) OK (0 msec) OK (0 msec) OK (0 msec) OK (10 msec) OK (0 msec) OK (0 msec) OK (0 msec)
tnsnames.ora
RSM.icada.net = (DESCRIPTION =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1521)))
(CONNECT_DATA =(SERVICE_NAME = RSM))) RSM_beq.icada.net =
(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = BEQ) (PROGRAM = oracle)
(ARGV0 = oracleRSM) (ARGS =
'(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))
(CONNECT_DATA = (SERVICE_NAME = RSM))) Does anyone know why this is the case?
Thanks,
pascal
Received on Tue Jul 23 2002 - 08:22:23 CDT