Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Bequeath vs. TNS connections

Bequeath vs. TNS connections

From: Pascal Byrne <nospam-byrne_at_icada.net>
Date: Tue, 23 Jul 2002 15:22:23 +0200
Message-ID: <ahjla2$sjgdp$1@ID-147008.news.dfncis.de>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US