Home » RDBMS Server » Performance Tuning » Windows vs Linux
Windows vs Linux [message #209568] Fri, 15 December 2006 10:21 Go to next message
Messages: 1
Registered: December 2006
Junior Member
I was hoping someone might provide me some insight to what is happening between a 32 bit Windows system and a 64 bit Linux system. We have a database Version 9.2.6 which was cloned from the 64 bit Linux system to a 32 bit Windows system. The same init.ora parameters were used on both and the explain plan on both is the same.

When the query is run it returns a total of 403 rows. The first 396 rows return in 10 seconds on both environments but the last 7 rows takes about another 2 seconds in Linux and 30 minutes in windows. I can understand that the speed of the 64 bit Linux is faster but the amount of memory utilized by Oracle is the same on both. I would expect a difference between the 32 bit windows and 64 bit Linux but not 30 minutes. Also, when this test is run in both cases only the user running the query is logged on the system.

Re: Windows vs Linux [message #209610 is a reply to message #209568] Fri, 15 December 2006 21:37 Go to previous message
Messages: 3727
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Trace both of them, run them through TK*Prof, and post both TK*Prof results here.

Ross Leishman
Previous Topic: Looking for a guru
Next Topic: Trace Oracle Job Session using tkprof
Goto Forum:

Current Time: Mon Jul 24 18:18:47 CDT 2017

Total time taken to generate the page: 0.17532 seconds