| 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
Ignore the previous solution - I was talking rubbish
How about this?
register an interest in 2 alerts, say SUCCESS and TIMEOUT submit a job to ping the remote database, then raise the SUCCESS signal submit a job to raise the TIMEOUT signal in 10 seconds wait for either signal
If the database responded you get SUCCESS, If the network is down, you get TIMEOUT in 10 secs
-----Original Message-----
From: Peter Miller=20
Sent: 24 June 2004 15:34
To: oracle-l_at_freelists.org
Subject: RE: Database Link Timer
DBMS_ALERT springs to mind
How about
register an interest in an Alert=3D20
submit a job to run in 10 secs that raises the afore mentioned alert
start the sql "ping"
unregister the interest in the Alert
the exception being to handle the alert raised by the job
-----Original Message-----
From: Jared Still [mailto:jkstill_at_cybcon.com]
Sent: 24 June 2004 15:28
To: Oracle-L Freelists
Subject: Re: Database Link Timer
PL/SQL does not have signals.
If you wrote this in a language that was more suited to systems programming, such as oh, say, Perl, this would be easy.
And no, I am not being facetious.=3D20
PL/SQL is not an appropriate tool for this kind of work.
You may be able to do this in Java, but I don't know.
Jared
On Thu, 2004-06-24 at 05:08, Mercadante, Thomas F wrote:
> All,
> =3D20
> I have the following query in a stored package:
> =3D20
> select 1 into loc_variables from dual_at_databaselink
> <mailto:dual_at_databaselink> ;
> =3D20
> What I am doing is checking the availabilty of the remote database
> periodically. The bad news is that we sometimes have network =3D
problems. If
> the above would fail, then I trap the error and move on. But =3D
sometimes, it
> is just painfully slow (like it doesn't fail but hangs for a long =3D
time).
> =3D20
> 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?
> =3D20
> thanks
> =3D20
> Tom Mercadante=3D20
> Oracle Certified Professional=3D20
>=3D20 >=3D20 >=3D20> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
-- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 Jun 24 2004 - 09:41:39 CDT
 |
 |