Greetings -

I have written PL/sql code that gathers tablespace information among 100's of Databases on a regular basis that would assist in our Capacity Planning Program. This code is configured using dbms scheduler on a central server/db.

At a high level, this code connects to each db by dynamically creating db link, captures tablespace space information to insert into the local table and drops the link.

The idea is to if the link is working fine, get the data. If not capture the error and move to the next DB. Now, this code is working like a champ. But, today, I stumbled upon issue when one remote DB connection had "Library Cache contention" due to which entire program was hanging.

Is there a way one can have timeout functionality built for Database Link Connections that will close the link after say 30/60 sec which can be captured as exception to let the code move to the next DB..

thanks
Ganesh