RE: Database Link Timer
- From: "Peter Miller" <Peter.Miller@xxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 24 Jun 2004 15:45:16 +0100
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@xxxxxxxxxxxxx
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@xxxxxxxxxx]
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@databaselink
> <mailto:dual@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
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
