一
、執行 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