Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL wait-, sleep or pause-function

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

From: Andrew Hardy <nobody_at_spam.from.news.AdvanticaTech.com>
Date: Mon, 12 Nov 2001 14:18:19 -0000
Message-ID: <9solo7$n0p$1@sun-cc204.lut.ac.uk>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US