6 Replies Latest reply: Apr 25, 2013 8:41 AM by Srini Chavali-Oracle RSS

    Insertion takes a long time after migrating from Windows to Linux (OEL6)

    Poorna Prakash
      Hi experts,

      Recently our team has migrated from Windows to Linux (OEL 6) by Export Import.
      Oracle 10.2.0.1 to 11.2.0.3 Standard Edition.

      Insertion takes too long time in all tables. (Reported that it was fine while it was on Windows)
      Also ive a table that has around 5 Crores records in it. Inserting in this table takes a very long time.

      Tried creating Index, Dropping and Recreating index
      Analyzing table,
      Analyzing index. Yet helpless.

      How to determine the cause.
      Please help.

      Thanks