Oracle Expert

spool bench_pq.log

create table objs tablespace tsb1 as
select * from dba_objects;

begin
for i in 2..10 loop
insert into objs select * from dba_objects;
commit;
end loop;
end;
/

create table objs2 tablespace tbs1 as
select * from objs where 1=0;

alter session set events ‘10046 trace name context forever, level 12′;
alter session set MAX_DUMP_FILE_SIZE= unlimited;
alter session set statistics_level=ALL;

insert into objs2
select /*+ parallel (objs */ * from objs;

alter session set events ‘10046 trace name context off’;

drop table objs;
drop table objs2;

spool off;