一.dbmslock.sleep简介procedure sleep(seconds in number);
-- Suspend the session for the specified period of time.
-- Input parameters:
-- seconds
-- In seconds, currently the maximum resolution is in hundreths of
-- a second (e.g., 1.00, 1.01, .99 are all legal and distinct values).
dbmslock.sleep(5);---括号内填写要休眠的秒数,即每处理完一条记录后,当前session休眠5秒钟。
二.存储位置
$ORACLE_HOME/rdbms/admin/dbmslock.sql
三.给用户授权
grant execute on dbms_lock to username;
四.举例说明用法
1.创建测试表
create table t_test(t_id number,t_date date);
2.插入数据
BEGIN
FOR I IN 1 .. 5 LOOP
INSERT INTO T_TEST VALUES (I, SYSDATE);
COMMIT;
DBMS_LOCK.SLEEP(5);
END LOOP;
END;
/
3.查询结果
select * from t_test;
---------------------------------------------------------------------
T_ID T_DATE
------- --------------------------
1 2014-2-27 17:22:58
2 2014-2-27 17:23:03
3 2014-2-27 17:23:08
4 2014-2-27 17:23:13
5 2014-2-27 17:23:18