INSERT INTO takes twice the time in 11.2.0.2 then in 10.2.0.4...
Hi!
We are running batches to test our new 11.2.0.2 database (move from 10.2.0.4).
In one of our batch jobs inserts takes twice the time (compared to 10g).
insert into hmw_tmp_build_repl_day values (b1 b2 b3 s)
insert into repl_day (select * from hmw_tmp_build_repl_day)
hmw_tmp_build_repl_day is a temp table with four columns. Zero rows rigth now. In PROD the table have never been analyzed and I guess it dont need to.
repl_day is a table with over 50million rows and fresh statistics.
Any good suggestions on where to start looking?
We are running batches to test our new 11.2.0.2 database (move from 10.2.0.4).
In one of our batch jobs inserts takes twice the time (compared to 10g).
insert into hmw_tmp_build_repl_day values (b1 b2 b3 s)
insert into repl_day (select * from hmw_tmp_build_repl_day)
hmw_tmp_build_repl_day is a temp table with four columns. Zero rows rigth now. In PROD the table have never been analyzed and I guess it dont need to.
repl_day is a table with over 50million rows and fresh statistics.
Any good suggestions on where to start looking?
0