DBLINK status check or query timeout through it
623104Nov 9 2010 — edited Nov 9 2010I am accessing some values through DB links in my triggers.The problem is if the remote db is down , the trigger much time (around 75sec) to give me error 12535, 00000, "TNS:operation timed out". I want to reduce this time , i tried changing in listener.ora
listener.ora:CONNECT_TIMEOUT_DB = 10
but no change.
I want to do this because it is impacting the speed of my insert/update on which i have created this trigger.
Is it possible to check the status of dblinks before proceeding with trigger ?
I tried putting select dummy from dual@dblink
but obviously it is still taking same time for the results.