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;