Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Runaway queries

Re: Runaway queries

From: Margaret Burwell <aj739_at_FreeNet.Carleton.CA>
Date: 27 Aug 1998 11:49:50 GMT
Message-ID: <6s3h4u$r1r@freenet-news.carleton.ca>

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 Aug 27 1998 - 06:49:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US