Re: Runaway queries

From: <plomax_at_oriolecorp.com>
Date: Fri, 04 Sep 1998 00:53:54 +0200
Message-ID: <35EF1E02.B33604C4@oriolecorp.com>

I must say as a final note that the banzai approach is a short term temporary mesure to stave off killing a production machine. When the schemas and statements have been identified it is up to development to correct the problem asap.
plomax_at_oriolecorp.com

Margaret Burwell wrote:

> UnixDBA (unixdba_at_aol.com) writes:
> > What version of Oracle are you using?
>
> It is Oracle7 Server Release 7.3.2.3.2 on a Dec Alpha running Open
> VMS 7.1
>
> Marg
>
> >
> >>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 - 17:53:54 CDT