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: Is there a way to initiate a timeout on long running queries ?

Re: Is there a way to initiate a timeout on long running queries ?

From: Tanel Poder <change_to_my_first_name_at_integrid.info>
Date: Wed, 27 Aug 2003 09:15:22 +0300
Message-ID: <3f4c4c7a$1_1@news.estpak.ee> 





You could check cpu_per_call and logical_reads_per_call in profiles. Or go
with composite_limit.



Tanel.



"Iyman Zakhary" <izakhary_at_vibrant-1.com> wrote in message
news:b01cd916.0308261225.e220c63_at_posting.google.com...


> I have a query that could take upto 15 minutes based on used parameters.

> Is there a way to timeout after 5 minutes ?

Received on Wed Aug 27 2003 - 01:15:22 CDT












Original text of this message













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