Problem solve Get help with specific problems with your technologies, process and projects.

Windows or open source for an ERP platform?

We are considering an ERP platform and have not yet closed in on our ERP vendor choice. We are however very, very close. Our enterprise level database of choice is Oracle regardless of our other choices. Can you tell me what are the primary considerations in terms of per user bottlenecks associated with delivering an ERP solution with an Oracle database on an open source versus Windows 2003 platform? We will most likely use 9i, but we haven't completely ruled out 10g as the database. We understand there to be a constraint of say approximately 500 concurrent users in an Oracle/Oracle on Windows environment. Is this driven by a per user memory requirement in the portal, since the database advertises huge SGA buffer limits up to 64 gigabytes and up to 10,000 users utilizing the Oracle Shared Server Process? Please help us with the trade-offs to consider.

There used to be a general rule of thumb that Oracle on Windows would not support much more than 500 concurrent users. The reason for this rule of thumb was due to the fact that Oracle on Windows did not handle Shared Server connections very well. You will be happy to know that Oracle 9i and Oracle 10g handle Shared Server connections very well. This rule of thumb is not applicable any more.

In today's Oracle environments, the decision to go with Windows or an open source operating like Linux depends more on your company's expertise. If you have Windows administrators but no Linux administrators, then it only makes sense to run Windows. If you have Unix or Linux administrators, but no Windows administrators, then choose Linux.

There are a few other reasons to choose Linux over Windows. Linux servers that do not run a GUI environment typically outperform Windows isntalled on the same hardware. The Windows server has to spend additional overhead supporting the GUI environment, even if no one is directly connected to the operating system. Oracle Corp is also coming out with many tools such as Linux clustering software, which can help you as well.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.