Re: Oracle Server Question

You need to be a lot more specific. What do you mean by a "very large amount" of data? How many tables, and how wide are they? How many rows per table for the initial load, and what's the growth? What is the nature of the transactions, and where do they come from? How is the data going to be queried? Will your historical queries (you mentioned 2 years of history) be at a detail or aggregate level, or some combination? What are your requirements for uptime and fault tolerance? Your user load seems to be very low, which is a good thing, unless those two or three people are doing nasty ad-hoc queries.

If you have already decided on unix, which I think is great, give Linux some consideration too (seriously). From your vague description so far, it sounds like a pretty small database and only hundreds of transactions per day is nothing. You can save a lot of money, and Linux is just as stable (although not as scalable, yet) as Solaris.

Dave Pulaski
Database Consultant

Dave wrote:

> Hey group,
>
> It's come time to quote on a server for our Oracle project that's upcoming.
> It contains a very large amount of data, with many hundreds of transactions
> per day, and we need to access data from about 2 years back at any time. We
> do not plan to integrate with the web any time soon, and will only have 2
> (very rarely 3, and almost never 4) people interacting with the database at
> one time. The plan is to run it on Solaris, it being a stable environment.
> Any suggestions as to which server(s) I should look at? Should I go with
> one from Sun, or Compaq, HP, etc? Any tips when looking for servers?
>
> Thanks In Advance
> ------
> Dave

--
David A. Pulaski
Database Consultant
dave_at_dpulaski.net
Home: 978-582-0820
Cell: 978-618-1377