oracle DBMS_LOCK.SLEEP()µÄʹÓÃ

Ò»
¡¢執ÐÐ ORACLE_HOME/rdbms/admin/dbmslock.sql À´´´½¨ dbms_lock;
-ÔÚDBAÉí·ÖÏÂgrant execute on dbms_lock to USERNAME;
-執ÐÐ測試´ú碼
begin
dbms_output.put_line(to_char(sysdate,'yyyymmddhh24miss'));
dbms_lock.sleep(60);
dbms_output.put_line(to_char(sysdate,'yyyymmddhh24miss'));
end;
---->
20090728092027
20090728092129
¶þ
1\´´½¨²âÊÔ±í
CREATE TABLE tbl_tt (ID NUMBER(4),addtime DATE);
2\¿ªÊ¼²âÊÔ
BEGIN
   FOR i IN 1 .. 10
   LOOP
      INSERT INTO tbl_tt
           VALUES (i, SYSDATE);
      COMMIT;
      DBMS_LOCK.sleep (5);
   END LOOP;
END;
/
3\²éѯÊý¾Ý
        ID ADDTIME
---------- -------------------
         1 2008-01-14 13:10:20
         2 2008-01-14 13:10:26
         3 2008-01-14 13:10:31
         4 2008-01-14 13:10:36
         5 2008-01-14 13:10:41
         6 2008-01-14 13:10:46
         7 2008-01-14 13:10:51
         8 2008-01-14 13:10:56
         9 2008-01-14 13:11:01
        10 2008-01-14 13:11:07