Re: Abort slow queries

From: ddf <>
Date: Fri, 20 Feb 2009 06:32:30 -0800 (PST)
Message-ID: <>

On Feb 20, 5:51 am, "Álvaro G. Vicario"
<> wrote:
> Is there any client setting to abort queries that take longer than X
> seconds?
> I'm developing web apps written in PHP 5.2 running as Apache 2.2 module
> with Oracle backend (via OCI8). I'm using Oracle Instant Client 10.2 to
> connect with a remove Oracle 9i Server ( Sometimes I run a
> poorly written or just plain wrong query while developing and the Oracle
> server goes berserk (99% CPU, slow responsiveness). I can hardly do
> anything else until it finishes the query or I ask the sysadmin to
> restart the service. Even restarting my own PC has no effect.
> PHP has a max_execution_time but it doesn't affect external processes.
> --
> -- Álvaro G. Vicario - Burgos, Spain
> -- Mi sitio sobre programación web:
> -- Mi web de humor al baño María:
> --

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

David Fitzjarrell Received on Fri Feb 20 2009 - 08:32:30 CST

Original text of this message