9 Replies Latest reply: Feb 14, 2013 3:45 AM by Paul Horth RSS

    Insert taking long time.

    user9077483
      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.