This discussion is archived
9 Replies Latest reply: Feb 14, 2013 1:45 AM by Paul Horth RSS

Insert taking long time.

user9077483 Newbie
Currently Being Moderated
Hi Experts,

I am inserting 25 lacs records into a table INTERFACE_ST.
I am using the hint /*+ append parallel(auto) */
INSERT /*+ append  parallel(auto) */ INTO INTERFACE_ST
SELECT * FROM INTERFACE_STORE;
Before performing this I have done the following.
ALTER SESSION SET PARALLEL_DEGREE_POLICY = AUTO;

ALTER SESSION ENABLE PARALLEL DML;
Still my insert is taking 30 mins.

I am using the version.
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit

Please help me.

Thanks.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points