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

Home -> Community -> Mailing Lists -> Oracle-L -> Perfomrance Issue When using BEQ protocol

Perfomrance Issue When using BEQ protocol

From: Ahmed Abdel Fattah <amfattah70_at_yahoo.com>
Date: Thu, 8 Jul 2004 00:09:38 -0700 (PDT)
Message-ID: <20040708070938.96049.qmail@web51909.mail.yahoo.com>


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:



Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=CIB-DW-PRD)(PORT=1521)) OK (10 msec)
TNS Ping Utility for Solaris: Version 8.1.7.2.0 - Production on 07-JUL-2004 17:4 5:56
(c) Copyright 1997 Oracle Corporation. All rights reserved.
Attempting to contact (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')) OK (160 msec)

TNS Ping Utility for Solaris: Version 8.1.7.2.0 - Production on 07-JUL-2004 17:4 6:00
(c) Copyright 1997 Oracle Corporation. All rights reserved.
Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=CIB-DW-PRD)(PORT=1521)) OK (10 msec)
TNS Ping Utility for Solaris: Version 8.1.7.2.0 - Production on 07-JUL-2004 17:4 6:00
(c) Copyright 1997 Oracle Corporation. All rights reserved.
Attempting to contact (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')) OK (70 msec)

TNS Ping Utility for Solaris: Version 8.1.7.2.0 - Production on 07-JUL-2004 17:4 6:03
(c) Copyright 1997 Oracle Corporation. All rights reserved.
Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=CIB-DW-PRD)(PORT=1521)) OK (10 msec)
TNS Ping Utility for Solaris: Version 8.1.7.2.0 - Production on 07-JUL-2004 17:4 6:03
(c) Copyright 1997 Oracle Corporation. All rights reserved.
Attempting to contact (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')) OK (60 msec)

TNS Ping Utility for Solaris: Version 8.1.7.2.0 - Production on 07-JUL-2004 17:4 6:06
(c) Copyright 1997 Oracle Corporation. All rights reserved.
Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=CIB-DW-PRD)(PORT=1521)) OK (10 msec)
TNS Ping Utility for Solaris: Version 8.1.7.2.0 - Production on 07-JUL-2004 17:4 6:06
(c) Copyright 1997 Oracle Corporation. All rights reserved.
Attempting to contact (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')) OK (70 msec)

TNS Ping Utility for Solaris: Version 8.1.7.2.0 - Production on 07-JUL-2004 17:4 6:10
(c) Copyright 1997 Oracle Corporation. All rights reserved.
Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=CIB-DW-PRD)(PORT=1521)) OK (0 msec)
TNS Ping Utility for Solaris: Version 8.1.7.2.0 - Production on 07-JUL-2004 17:4 6:10
(c) Copyright 1997 Oracle Corporation. All rights reserved.
Attempting to contact (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')) OK (150 msec)

Can someone till me if this is a normal behavior? Is I missing some information?  

Thanks & Best Regards
Ahmed                 



Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!

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:06:15 CDT

Original text of this message

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