Can anybody on the board please let me know how to identify a broken database link??? Let me explain the scenario...We have two databases, X1 and X2. During certain point in our processing we push some data from X2 to X1. For this we are using a database link. After making the connection, for some (network) reason, the link breaks and the application hangs without throwing any error. Especially if this happens in the evening when everyone has left the office, this problem is not noticed till the next morning. I shall be glad if anyone can tell me if there is any way to identify this situation so that the problem can be immediately identified.

Thanks in advance.