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: Timeout any SQL?

Re: Timeout any SQL?

From: suvas <suvas_at_pacific.net.sg>
Date: 1996/11/12
Message-ID: <01bbd125$d5a55d00$785478cb@Singnet.singnet.com.sg>#1/1

It is possible and highly desirable to do it. If u have luck your Interrupt character(typically ^c) will do it. Else if u are in unix issue a "kill <pid>" .

-=[ CE Raymond ]=- <kp1wong_at_cs.hku.hk> wrote in article <55pi5g$6iv_at_ns.cs.hku.hk>...
> Hello all!
>
> If I submitted a SQL statement which listed out the join of all tables in
> my view, is it possible to "kill" the query if the Oracle server not
> returned the result in a certain period of time?
>
> Best regards,
> Raymond
>
  Received on Tue Nov 12 1996 - 00:00:00 CST

Original text of this message

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