循环一次间隔时间为1秒 ORACLE 采用SYS.DBMS_LOCK的包,说明 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).
ORACLE 采用SYS.DBMS_LOCK的包,说明
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).
在同步前计算时间,同步完成后又计算时间,然后用1秒减,exec dbms_lock.sleep
然后进行下一次循环。