Re: PL/SQL wait-, sleep or pause-function

From: Richard Kuhler <noone_at_nowhere.com>
Date: Mon, 12 Nov 2001 18:40:47 GMT
Message-ID: <PIUH7.33347$D5.11899192@typhoon.san.rr.com>

Sleeping and polling explicitly probably isn't the most efficient way to do this. I would suggest you try to use DBMS_ALERT. Just have the daemon wait on an alert and then have whatever the triggering event is signal an alert to wake the daemon.

Richard

Bernd Bast wrote:
>
> hi,
>
> i'm trying to program some sort of daemon in PL/SQL which will submit
> jobs to the oracle user_jobs_queue. This daemon should - like every
> daemon do - be running in an endless loop forfilling his tasks.
> Unfortunately the process consumes too much cpu. Do you know a
> function to force this PL/SQL-Procedure to sleep (pause or wait) for a
> certain amont of time without consuming too much CPU time?
>
> Help/Advice appreciated.
>
> Thanx a lot,
> Bernd.
Received on Mon Nov 12 2001 - 12:40:47 CST