hello all
Is there any way to control the timeout before connecting via dblink.
the idea is to test the dblink before calling functions over it, the problem it when i try 'select 1 from dual@dblink' in case if the remote server is down it takes too long time 5-7 min. which causing hang up the session,
So is there any parameter to reduce the waiting time say after 3 sec stop and return the timeout exception.
I try the SQLNET.INBOUND_CONNECT_TIMEOUT parameter but not working, also try the tnsping but it alse take long time when the server down.

the database version is 10gr2.
Regards.

Hi,

>> Is there any way to control the timeout before connecting via dblink.

Before?

I've written systems where each transactions is one second, no more,no leess, not never a deliberate delay at connect time!

Hi,

>> Is there any way to control the timeout before connecting via dblink.

Before?

I've written systems where each transactions is one second, no more,no leess, not never a deliberate delay at connect time!