| 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
Ahmed,
I am not sure that your test is really significant - I mean that it probably
doesn't measure what you are interested in.
tnsping just talks to the listener, and as listeners are usually mean to
talkto clients over a network, it isn't necessarily optimised for this type
of test. It would be much better to do a select in a loop (PL/SQL block)
across one database link and across the other before jumping to
anyconclusion.
BTW specifying the host as 'localhost' should further improve response times
in the TCP case I believe.
Regards,
Stephane Faroult
On Thu, 8 Jul 2004 00:09 , Ahmed Abdel Fattah <amfattah70_at_yahoo.com> sent:
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:
-- 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:40:51 CDT
 |
 |