Oracle语句块耗时

方法一：

declare
  cnt    number;
  b_time number;
  e_time number;
begin
  cnt    := 0;
  b_time := DBMS_UTILITY.GET_TIME;
  while cnt < 10 loop
    do something ...;
    commit;
    cnt := cnt + 1;
  end loop;
  e_time := DBMS_UTILITY.GET_TIME;
  DBMS_OUTPUT.put_line('Elapsed :' || (e_time - b_time) / 100 || ' s');
end;
/

方法二：

declare
  cnt    number;
  b_time timestamp;
  e_time timestamp;
begin
  cnt := 0;
  select sysdate into b_time from dual;
  while cnt < 10 loop
    do something .. .;
    commit;
    cnt := cnt + 1;
  end loop;
  select sysdate into e_time from dual;
  DBMS_OUTPUT.put_line('Elapsed:' ||
                       to_char((e_time - b_time) * 24 * 60 * 60) || ' s');
end;
/

在命令行模式下

set serveroutput on;