1.
create table t_ref as select * from all_objects;
insert into t_ref select * from t;
insert into t_ref select * from t;
insert into t_ref select * from t;
insert into t_ref select * from t;
insert into t_ref select * from t;
2.模拟逐行提交的情况,注意观察执行时间
目标是将t_ref表中的数据全部插入到t中
set timing on
DECLARE
BE
create table t_ref as select * from all_objects;
insert into t_ref select * from t;
insert into t_ref select * from t;
insert into t_ref select * from t;
insert into t_ref select * from t;
insert into t_ref select * from t;
2.模拟逐行提交的情况,注意观察执行时间
目标是将t_ref表中的数据全部插入到t中
set timing on
DECLARE
BE