Re: test if dblink is up

Andreas Moroder wrote:
> Hello,
>
> we have a DB-Link over a WAN. When the dblink goes down the application
> blocks and gets a oracle error only after 30 minutes.
>
> Is there a way to test if a dblink is up whit a shorter timeout ( say 30
> seconds ) ?
>
> Thanks
> Andreas

SELECT sysdate
FROM dual@<remote>;
should return rather quickly.

But the nature of your "application" might be important to know. Version, operating system, etc. helpful.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org