Re: Sleep in PL/SQL?
From: Austin Moseley <\"moseba_at_audv55.aud.alcatel.com'>
Date: 1996/03/23
Message-ID: <4ivvfb$dh_at_news01.aud.alcatel.com>#1/1
Date: 1996/03/23
Message-ID: <4ivvfb$dh_at_news01.aud.alcatel.com>#1/1
Andre Rusanoff <arusanoff_at_maxwell.attmail.com> wrote:
>Chuck Hamilton wrote:
>>
>> Is there any way to tell PL/SQL to sleep for X seconds before
>> proceeding to the next line of code?
>If not, just enter a loop within your PL/SQL block and keep selecting
>to_char(sysdate,'SS') until the difference between first and last results
>is equal to X and then exit the loop.
The DBMS sleep call is best. The first thing I'd do when tuning a problem system is look for these loops, both in the 3gl and the SQL. During peak loads they'll eat your CPU down, while I/O is cool. Call your hibernate routine in the 3gl.
-Austin Received on Sat Mar 23 1996 - 00:00:00 CET