Re: Runaway queries

Hi,
There is a dirty solution or banzai approach to this problem. 1. Monitor and if you see that a user is consuming lots of CPU 2. Scan the SQL area
If you look at your SQL area then you should be able to track down the statements that are run
that cause you problems.
A little kill in unix or stop/id should do the trick. This is to be used with extreme care and preferably only on selects. You could screw the integrity of your database. Cheers
Peter
Ask auntie for other problems
aunt_augusta_at_oriolecorp.com

UnixDBA wrote:

> What version of Oracle are you using?
>
> >Subject: Runaway queries
> >From: aj739_at_FreeNet.Carleton.CA (Margaret Burwell)
> >Date: 8/26/98 12:32 PM EST
> >Message-id: <6s1grd$9mo_at_freenet-news.carleton.ca>
> >
> >
> >Does anyone have any suggestions on how to get rid of runaway queries? We
> >have tried dead connection and setting limits in the oracle profile, but
> >so far we haven't had much success. We would like to be able to set a
> >time limit after which the query would be cancelled if it hasn't returned
> >any data.
> >
> >Marg
> >
> >
> >
Received on Thu Sep 03 1998 - 13:59:44 CDT