| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Perfomrance Issue When using BEQ protocol
Hi Ahmed,
Unfortunately I haven’t experience using BEQ protocol (Just TCP/IP and IPC
if DB-es located on the same machine).
But one thought coming to my mind:
I wouldn’t test network protocol performance just by TNSPING.
I would try to resend some amount of data though both protocol, which
performance I going to compare.
Jurijs
9268222
Ahmed Abdel Fattah <amfattah70_at_yahoo.com>
Sent by: oracle-l-bounce_at_freelists.org
08.07.2004 10:09
Please respond to oracle-l
To: oracle-l_at_freelists.org
cc:
Subject: Perfomrance Issue When using BEQ protocol
Dear All,
I have an environment that has two databases, OFSA & ODS.
Database ODS has a database link to the OFSA database. This
database link uses a connect string called OFSA, which is defined
as follows:
OFSA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = CI-DW-PRD)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME =OFSA)
)
)
There is a batch job that run on the server and that uses the above
database link to retrieve some data from the OFSA database.
Due to performance issues on the above batch job, I suggested to implement
the BEQ protocol in the connect string that is used by the above databse
link
as long as the two databases are on the same server, and because I read
some
documents that BEQ is faster than TCP/IP. So, I created another connect
string
as follows:
PROD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = BEQ)(PROGRAM = oracle)(ARGV0 = oracleOFSA)(ARGS
= '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))')(ENVS =
'ORACLE_SID=OFSA,ORACLE_HOME=/apps/oracle/product/8.1.7'))
)
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:
Thanks & Best Regards
Ahmed
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- 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 - 02:33:53 CDT
 |
 |