Re: Protect against the query from hell ?

Give all users who are going to running the ad-hoc queries a profile. You can limit the cpu_per_call via a profile. You may also want to limit the logical_reads_per_call. (also done via the profile).

Terry Ball
Sr. DBA, CSG Systems

Ferdinand Swaters wrote:

> Hi all,
>
> In a database system I'm currently designing, users can place ad-hoc queries
> on a huge set of data. A small error in the query may result in a query from
> hell, one that runs almost forever or returns several terabytes of data.
> The superlarge output result can easily be solved by a limiting clause on
> ROWNUM, but how about runtime?
>
> Is there a way to limit the runtime of a query, so that it can abort when
> the runtime is extremely long?
>
> advTHANKSance,
>
> Ferdinand Swaters
> Incore Automatisering B.V.
Received on Wed Jun 02 1999 - 20:05:22 CEST