This discussion is archived
6 Replies Latest reply: Apr 25, 2013 6:41 AM by Srini Chavali-Oracle RSS

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

Poorna Prakash Newbie
Currently Being Moderated
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

Legend

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