Re: Perfomrance Issue When using BEQ protocol

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Thu, 8 Jul 2004 11:34:42 +0300
Message-ID: <016101c464c6$6bf8dbb0$bff923d5@porgand>

Hi!

> The I test connection using the two connect strings, using the tnsping
utility
> over a period of time, and I found that using the BEQ connect string is
much
> slower than using the TCP/IP connect string. Following are sample test
results:

Since the BEQ protocol doesn't use a listener, tnsping has to spawn an oracle process to be able to test the connection and this takes time. With IPC and TCP, you already have a listener up and running and just returning answer from it is much faster.

But as Stephane and Jurijs here already mentioned, you should test performance of an already open connection from your application, not using tnsping.

Tanel.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Jul 08 2004 - 03:31:24 CDT