Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Failed DB link

Failed DB link

From: Chuck Hamilton <chuck_hamilton_at_yahoo.com>
Date: Fri, 23 Mar 2001 10:41:18 -0800
Message-ID: <F001.002D650C.20010323094602@fatcity.com>


I ran into a situation this week where a session was waiting for results from a failed db link and holding a lock (library cache pin) on the sql it was executing. It never detected the failure and hung waiting for a reply on the link. This caused the pin to be help indefinitely too, which caused numerous other sessions to hang as they tried to pin either the same sql. What can I do to ensure that if a db link fails (it failed due to a network adapter failure on the remote server), the session will either abort or return an error? Will setting sqlnet.expire_time on the remote server do this?Do You Yahoo!? Yahoo! Mail Personal Address -
Get email at your own domain with Yahoo! Mail. Received on Fri Mar 23 2001 - 12:41:18 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US