Re: Query timeout

On Fri, 21 Nov 2003 07:58:21 -0500, "ReplyToGroups" <sorry_at_NoAddress.com> wrote:

>Hi
>
>Is there anyway I can break the long running query after 'x' minutes. I
>wanted to do this in procedure.
>Let's say if the query runs more than 2 minutes then I wanted to Exit the
>procedure and send the message to the user.
>
>Thanks
>Sync
>

Basically there are 2 solutions

1. tune the query
2. enable resource limits for the database and set up an appropiate profile and assign that to appropiate user accounts.

Note: in the latter case end-users will continue to suffer from untuned queries. This solution can be labelled as symptom-fighting and is not preferred.

--
Sybrand Bakker, Senior Oracle DBA