Re: Stopping run-away Oracle queries

From: Keith Boulton <boulke_at_globalnet.co.uk>
Date: Thu, 25 Nov 1999 11:25:35 GMT
Message-ID: <3839c3d7.11063010@read.news.globalnet.co.uk>

On Fri, 19 Nov 1999 16:39:32 GMT, peterjoh_at_my-deja.com wrote:

>Hi all.
>Is it possible to stop 'run-away' queries on Oracle 8.0.5?
>
>We are running netscape enterprise server, on Solaris, talking to
>Oracle, and sometimes we create stupid queries that take forever
>(almost) to complete. We need to abort these queries and free up the
>oracle server for a new request.

Could you use a profile limiting cpu use per statement? Received on Thu Nov 25 1999 - 05:25:35 CST