Ask the Expert

Platform for implementing a 100 GB database on Oracle 8i/9i

We plan to implement a 100GB database on Oracle 8i/9i. The daily inflow of data would be around 100MB. We would have a limited number of users connecting at any given time (not more than 40). The application is supposed to be 365X24X7, although periodic downtime for maintenance purposes may be permissible. The application may also need to scale well with time. Could you please suggest a suitable platform for the same? Are we right in assuming that the scalability factor knocks NT/2000 out of the equation? We are currently looking at HP-UNIX and SUN Solaris as possible options. Kindly advise.

    Requires Free Membership to View

Windows NT/2000 may or may not be out of your equation depending on who you ask. If you ask Microsoft, your database should scale well. But I believe that most DBAs would suggest a Unix platform if you are worried about scalability (and availability). Win2000 has gotten better, but most people tend to favor Unix. Of course, you could start off on Windows and then transport your database to a Unix platform in the future should your application need to scale to handle future growth. Or you could just start off on a Unix platform from the beginning.

Both HP-Unix and Sun Solaris are very fine systems. If I had to choose one, I would choose Solaris over HP. Solaris is Oracle's development platform for the Oracle RDBMS. They write the database code on Solaris first and the port it over to HP (and other platforms) later. New releases, bug fixes, and patchsets appear for Solaris before other platforms. Also, Solaris is called a "Tier 1" platform by Oracle. Platforms that are Tier 1 receive the new releases, bug fixes, and patchsets before any platform in Tier 2 or 3. Tier 1 platforms include Sun Solaris, Windows NT/2000 and Linux. HP-Unix is a Tier 2 platform for Oracle. While HP-Unix is a very good Unix platform, it does not receive the attention from Oracle that Tier 1 platforms do. If at all possible, I like to stay on Tier 1 platforms. And Sun Solaris is the best one for that!

You also have to take into account your organization's current skill set. Are all of your System Administrators HP literate or Sun literate? If all your SysAdmins work on HP systems, you may encounter resistance to change and a big learning curve for them to get up to speed on a Solaris platform. This may or may not help make your decision for you.

For More Information


This was first published in June 2001

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: