1 sqlplus里set timing on SQL> set timing on SQL> create or replace procedure test 2 is 3 begin 4 null; 5 end; 6 /过程已创建。已用时间: 00: 00: 00.35 SQL> exec testPL/SQL 过程已成功完成。已用时间: 00: 00: 00.00 SQL>2 在存储过程里获取系统时间,分别在过程最开始和最后获取,然后两时间相减,就是过程的执行时间。
create or replace procedure gettime is type rc is ref cursor; l_rc rc; l_dummy all_objects.object_name%type; l_start number default dbms_utility.get_time; begin for i in 1..1000 loop open l_rc for 'select object_name from all_objects where object_id='||i; fetch l_rc into l_dummy; close l_rc; end loop; dbms_output.put_line (round((dbms_utility.get_time-l_start)/100,2)||'seconds'); end;
SQL> set timing on
SQL> create or replace procedure test
2 is
3 begin
4 null;
5 end;
6 /过程已创建。已用时间: 00: 00: 00.35
SQL> exec testPL/SQL 过程已成功完成。已用时间: 00: 00: 00.00
SQL>2 在存储过程里获取系统时间,分别在过程最开始和最后获取,然后两时间相减,就是过程的执行时间。
type rc is ref cursor;
l_rc rc;
l_dummy all_objects.object_name%type;
l_start number default dbms_utility.get_time;
begin
for i in 1..1000
loop
open l_rc for 'select object_name from all_objects
where object_id='||i;
fetch l_rc into l_dummy;
close l_rc;
end loop;
dbms_output.put_line
(round((dbms_utility.get_time-l_start)/100,2)||'seconds');
end;