| Windows vs Linux [message #209568] |
Fri, 15 December 2006 10:21  |
dfmflinn
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.
Thanks,
Dennis
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
