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 -> PL/SQL wait-, sleep or pause-function

PL/SQL wait-, sleep or pause-function

From: Bernd Bast <Bernd.Bast_at_delbrueck.de>
Date: 12 Nov 2001 06:00:09 -0800
Message-ID: <4d24bb33.0111120600.5bded1f5@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:00:09 CST












Original text of this message













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