What would be the server requirements for Oracle 8i database for 100 users? Also consider that there will be 1000 transactions a day from the Web. Thanks for your time.
It's always hard to answer these types of questions. But 100 concurrent users performing up to 1,000 daily transactions is not a lot. So you really don't need a very large database server. You can go with a low-end Unix server, a Linux server, or even a Windows server with this type of traffic. But be prepared to move your database to a bigger Unix box in the future if your usage requirements increase. No matter which server platform you do pick, try to get a box with more than one processor and multiple disk volumes. This way, you can spread the load out. This is important as your database usage begins to increase. You don't want to have to move to a different platform right away. Give yourself some capacity growth.
For More Information
- Dozens more answers to tough Oracle questions from Brian Peasland are available.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
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.