Re: Setting up a query timeout on Oracle8/SunOS

Create a profile and assign it to users, you can then limit system resources on session or call level.

Homepages wrote:
>
> 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

--
Ilusat suve...

     \  |  /
      \ | /
 -----(   )-----
      / | \
     /  |  \

...ja päikest :)

Juku Received on Tue Aug 17 1999 - 10:00:54 CDT