Oracle performance under NT versus Linux environments
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.
Software/Hardware used:
Software/Hardware used:
ASKED:
May 23, 2008 3:21 PM
UPDATED:
May 23, 2008 4:59 PM
RELATED QUESTIONS
- CIFS vs NETBIOS & network performance
- When doing a chain the (HI) indicator return with '1'. But if I do a query on the same file I can see that the record is in the file.
- Writing to block device is *slower* than writing to the filesystem?
- Record lock on physical file
- Need help on running combination of Nagios, Nconf, and Nagiosgraph on Linux
Answer Wiki:
It could be any number of things. Disk speed, CPU power, etc will probably be the biggest variables.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
