Re: Abort slow queries

From: Álvaro G. Vicario <alvaro.NOSPAMTHANX_at_demogracia.com>
Date: Mon, 23 Feb 2009 13:38:07 +0100
Message-ID: <gnu5bh$j79$1_at_news.motzarella.org>



ddf escribió:
>> Is there any client setting to abort queries that take longer than X >> seconds?

> Set up a resource profile which limits CPU and memory usage and
> associate that with the user account executing the queries. Should a
> query exceed the set limits it will be killed by Oracle. Start
> reading here
>
> http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_6010.htm#SQLRF01310

Thank you very much, it looks exactly what I need.

-- 
-- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web: http://bits.demogracia.com
-- Mi web de humor al baño María: http://www.demogracia.com
--
Received on Mon Feb 23 2009 - 06:38:07 CST

Original text of this message