Re: timer to terminate a long running process

From: Simon Griffiths <s.griffiths_at_virgin.net>
Date: 1998/06/27
Message-ID: <3594BDBF.5D278E7D@virgin.net>#1/1

dragon wrote:

> Is there a way in plsql or pro*c, preferably in plsql, to trigger a
> timer before running a database process? and if the process runs over
> the specified time limit I would like to stop the process gracefully
> and also set a warning flag in a table.
>
> In pro*c, I could use the timer function, but can I stop the long
> running process? Is there a similar function in plsql package that
> will do the same thing?
>
> It seems to me it has to be two-threaded, one for the process and the
> other for the monitoring timer.
>
> I'd appreciate any input or suggestions.
>
> --cs

Not really, but you could use profiles ( see CREATE PROFILE in the SQL Manuals)
to put various limits on sql calls and/or sessions

Simon. Received on Sat Jun 27 1998 - 00:00:00 CDT