Query through database link gets lost

2003-04-02 Thread Smith, Ron L.
I have a monitoring script that polls and monitors all the databases through a database link. If someone happens to shutdown or delete a database, the SQL connection through the database link just seems to hang forever and screws everything up. Can someone tell me how to set a time limit on the

RE: Query through database link gets lost

2003-04-02 Thread Jacques Kilchoer
Title: RE: Query through database link gets lost Are all these database similar versions of Oracle, or are they all different versions? When I did something similar I had my monitoring script connect to a database, poll for the necessary information, disconnect, and then connect to another