首页 » ORACLE » JOBRUNNINGLOG的创建-计算程序运行时间-自建JOB监控日志

JOBRUNNINGLOG的创建-计算程序运行时间-自建JOB监控日志

———–计算程序运行时间–AUTHOR:西安-KK———
DECLARE
time_before BINARY_INTEGER;
time_after BINARY_INTEGER;
time_begintime date;
time_endtime date;
BEGIN
time_before := DBMS_UTILITY.GET_TIME;
time_begintime := sysdate;
DBMS_OUTPUT.PUT_LINE(to_char(time_begintime,’yyyy-mm-dd hh24:mi:ss’));
begin
pac_shujuzlfx_null_wyx_jlzs.P_SHUJUZL_JILUZS_UPDATE;
end;
time_after := DBMS_UTILITY.GET_TIME;
time_endtime:= sysdate;
DBMS_OUTPUT.PUT_LINE(to_char(time_endtime,’yyyy-mm-dd hh24:mi:ss’));
DBMS_OUTPUT.PUT_LINE (‘已完成,耗时’||round((time_after – time_before)/100,4)||’秒’);
END;

打赏

目前这篇文章有1条评论(Rss)评论关闭。

  1. Rema Belletto | #1
    2011-12-21 at 04:26

    As I web site possessor I believe the content matter here is rattling great , appreciate it for your hard work. You should keep it up forever! Good Luck.