Re: Setting up a query timeout on Oracle8/SunOS

You need to look into resources and profiles.

A user id can have a profile, and a profile can be given several resource limits (such as CPU seconds per call, logical I/O per call)

This could meet your requirement

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Homepages wrote in message
<934882436.24265.0.nnrp-08.c2dead46_at_news.demon.co.uk>...
>Hi
>
>I'm after setting up a timeout, of say ten minutes, on queries on the
>database that sits behind our webserver - occasionally the queries take
>almost an hour to come back - the visitor to the website would have gone
>somewhere else at least 55 minutes before :-)
>
>Is there any way to set this up at a database level - I've had a good look
>through the oracle setup files but to no avail - all suggestions gratefully
>received. I'm loathed to do it by an alarm as the database is driven from
>Perl which isn't too good at handling alarms ...
>
>tom
>---------------------------------------------------------------------------
-
>---------------------
>Tom Hartley +44 181 763 2445
>Technical Director tom.hartley_at_homepages.co.uk
>Homepages Ltd www.homepages.co.uk
>
> HOMEpages - Site of your next home in the UK
>
>
>
Received on Tue Aug 17 1999 - 05:24:23 CDT