-DB "D7" on Oracle 7.3, WinNT4 , Server "S7"
-DB "D9" on Oracle 9i, Win2003, Server "S9"
-A DB link "DL" in D7 to connect to D9
-Issued "desc TblEmp@DL" from sqlplus in D7 on S7 (TblEmp is a table in D9)
When server S9 is UP: Output displayed within a second...so no problem.
When server S9 is DOWN: Error displayed "Unable to connect..." after about 45 sec. (Note: Error is not a problem for me)
Question : I think it takes about 45 sec for server S7 (or D7) to realise server S9 (or Database D9) is down.
Is there anyway this time (45 sec) can be reduced (to say 1 or 2 sec) or eliminated ?? ( Is this possible thru Oracle itself ? E.g. parameter setting or command )
(I've tried tnsping - It returns the error result very fast but I don't know how to issue & trap this from SQL, specifically trigger).
(Please note my actual requirement is quite complex - I've put a simplified one here - hence it will be difficult for me to elaborate the same now, though i can elaborate if need be).