Question

  Asked: May 23 2008   3:21 PM GMT
  Asked by: OracleATE


Oracle performance under NT versus Linux environments


Oracle performance, Linux, Windows NT, Oracle

When we run an update against a table of 40k rows on a NT environment, it completes in 10 sec.

When the same update is executed on a Linux environment with the same # of records, it completes in 19 sec - nearly 100% drop in performance.

The explain plans are the same for both environments (NT and Linux)

I know it’s a very generic question but would appreciate if you could provide some pointers to why there is this difference and how I can diagnose and fix this. Thank you.

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0



It could be any number of things. Disk speed, CPU power, etc will probably be the biggest variables.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Oracle, Linux and Microsoft Windows.

Looking for relevant Oracle Whitepapers? Visit the SearchOracle.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register