Re: Urgent: Timeout on queries

From: Gerrit-Jan Linker <linker_at_oraxcel.com>
Date: Wed, 5 Apr 2000 09:18:54 +0100
Message-ID: <8cfkgf$vvo$1@newsg3.svr.pol.co.uk>

I recall that you can setup something that restricts the user from accessing the database. Is it profiles you need to look at? Anyways there is something you can apply to users so you restrict their cpu usage. I'm sure you can do something useful with that to restrict the query time allowed.

Regards,
--
Gerrit-Jan Linker

web: http://www.oraxcel.com
email: gjlinker_at_oraxcel.com

Oraxcel: Linking Oracle to Excel
OraCodes: Explaining ORA- error codes
OraSQL: Explaining Oracle SQL syntax
OraDebug: PL/SQL debugger
OraWeb: Oracle access from IE
Klaus Sparrer <ksparrer_at_debis.com> wrote in message news:38EAEC3E.98DB5DD7_at_debis.com...
> Hi,
>
> as I need to guarantee a response within a given time I need to know a
> way to limit the time a query consumes to e.g. 30 seconds. The desired
> result is either the requested data (within the given time) or a timeout
> error message.
> Is there a way to implement this without having administrative access,
> i.e. via additional parameters.
> The application accesses the database via Embedded SQL, the database
> version is 7.3.4.
>
> TNX
>
> Klaus++
>
>
Received on Wed Apr 05 2000 - 03:18:54 CDT