直接insert與儲存過程insert效能區別

16:40:43 SQL> insert into t_direct_table select level from dual connect by level<=1e6;
 
1000000 rows inserted
 
Executed in 1.108 seconds
 
16:41:11 SQL> insert into t_direct_table select * from t_direct_table;
 
1000000 rows inserted
 
Executed in 0.562 seconds
 
16:41:26 SQL> create or replace procedure proc_t_direct_table
           2  as
           3  begin
           4  insert into t_direct_table select level from dual connect by level<=1e6;
           5  insert into t_direct_table select * from t_direct_table;
           6  commit;
           7  end;
           8  /
 
Procedure created
 
Executed in 1.372 seconds
 
16:44:17 SQL> truncate table t_direct_table;
 
Table truncated
 
Executed in 7.722 seconds
 
16:45:37 SQL> exec proc_t_direct_table;
 
PL/SQL procedure successfully completed
 
Executed in 1.716 seconds