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?
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