Hardware requirements for Oracle server on Unix

Hardware requirements for Oracle server on Unix

I need to decide the best hardware requirement for the following specifications:
  1. HP Unix OS.
  2. Oracle Database Server to handle more than 150 million voucher details (each voucher may contain 512 bytes).
  3. My Web application should support about 5,000 simultaneous users.
Could you help?

    Requires Free Membership to View

    By submitting your registration information to SearchOracle.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchOracle.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

Since your requirement limits you to HP-UX, then you will need a Unix server from Hewlett Packard. I would talk with the vendor to ensure that they spec out a good server for you.

The Oracle database will be able to handle 150 million rows of data. What will make a difference is the queries that touch the 150 million rows of data. If those queries are not optimized, the queries will not run fast. And you may need to employ partitioning to improve query performance.

Five thousand concurrent users can pose a problem. If they all connect to an application server, then make sure that the application server supports connection pooling. You may also need to use shared server on the Oracle database side of things to support many concurrent connections.

I would work with the HP vendor to scope out your I/O, memory and CPU requirements. Those will drive the server you will need to procure. HP has plenty of resources to help you with this.

This was first published in January 2007

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.