How do I set a run time limit for long queries ?

From: <rock_cogar_at_my-deja.com>
Date: Wed, 11 Aug 1999 13:04:15 GMT
Message-ID: <7orsc8$5bg$1@nnrp1.deja.com>

Hi,

I have some long queries that are sent from a Cold Fusion page on a Tennessee web server to a remote Oracle 8.1.5 database in Nebraska.

Sometimes, a query will take many minutes rather than seconds to run and prevents, or at least inhibits the use of other queries on that Oracle server. So of course, the DBA in Nebraska wants a solution, he would like to set a run time limit to the queries that we submit.

Thanks,
Rock Cogar. DBA
Radian International, TN

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Aug 11 1999 - 08:04:15 CDT