Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL wait-, sleep or pause-function
How about DBMS_LOCK.SLEEP?
Andy
"Bernd Bast" <Bernd.Bast_at_delbrueck.de> wrote in message
news:4d24bb33.0111120600.5bded1f5_at_posting.google.com...
> 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 - 08:18:19 CST