SQL> create table t (n number) 2 / Table created. SQL> declare 2 start_time number; 3 begin 4 start_time := dbms_utility.get_time; 5 for i in 0..999 loop 6 insert into t values (i); 7 end loop; 8 commit; 9 dbms_output.put_line(dbms_utility.get_time - start_time || ' centiseconds'); 10 end; 11 / 44 centiseconds PL/SQL procedure successfully completed. SQL> truncate table t 2 / Table truncated. SQL> declare 2 start_time number; 3 begin 4 start_time := dbms_utility.get_time; 5 for i in 0..999 loop 6 insert into t values (i); 7 commit; 8 end loop; 9 dbms_output.put_line(dbms_utility.get_time - start_time || ' centiseconds'); 10 end; 11 / 102 centiseconds PL/SQL procedure successfully completed. SQL> exit