| 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: Database Link Timer
Probably a little heavier weight than you'd like, but if you put a timer on
an entire sqlplus startup connection to the remote database you just need a
way to check whether the job has completed. (varying degree of difficulty
depending on OS). If you don't do this TOO often, such that you generate
unacceptable load, it is pretty cool to have a log of connection time plus
light weight query plus logoff end to end time versus time of date for each
system. Some folks even use this to get an early warning that someone is
about to complain that the "whole system is slow" (in this case something is
making logins slow).
mwf
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Mercadante, Thomas F
Sent: Thursday, June 24, 2004 8:09 AM
To: 'oracle-l_at_freelists.org'
Subject: Database Link Timer
All,
I have the following query in a stored package:
select 1 into loc_variables from dual_at_databaselink <mailto:dual_at_databaselink> ;
What I am doing is checking the availabilty of the remote database periodically. The bad news is that we sometimes have network problems. If the above would fail, then I trap the error and move on. But sometimes, it is just painfully slow (like it doesn't fail but hangs for a long time).
Is there some way I can put a timer on the above that says if it can't complete the query in 10 seconds, then fail?
thanks
Tom Mercadante
Oracle Certified Professional
 |
 |