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: SLEEP Procs

Re: SLEEP Procs

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 14 Jan 2007 16:31:14 -0800
Message-ID: <1168821072.886044@bubbleator.drizzle.com>


DA Morgan wrote:
> Jonathan Lewis wrote:

>>
>> Did you check for the "long" sleep problem that the
>> FAQ describes.

>
> Not yet. If time permits I will try it later today.

Here are the first two results:

SQL> DECLARE
   2 stime TIMESTAMP(9);
   3 etime TIMESTAMP(9);
   4 BEGIN
   5 stime := SYSTIMESTAMP;
   6 dbms_backup_restore.sleep(2100);    7 etime := SYSTIMESTAMP;
   8 dbms_output.put_line(etime-stime);    9 END;
  10 /

PL/SQL procedure successfully completed.

SQL> set serveroutput on
SQL> /
+000000000 00:35:00.000000000

PL/SQL procedure successfully completed.

SQL> select 2100/60 from dual;

    2100/60


         35

SQL> DECLARE
   2 stime TIMESTAMP(9);
   3 etime TIMESTAMP(9);
   4 BEGIN
   5 stime := SYSTIMESTAMP;
   6 dbms_drs.sleep(2100);
   7 etime := SYSTIMESTAMP;
   8 dbms_output.put_line(etime-stime);    9 END;
  10 /
+000000000 00:35:00.000000000

PL/SQL procedure successfully completed.

SQL> So far so good.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sun Jan 14 2007 - 18:31:14 CST

Original text of this message

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