Re: Big Oracle database question

Mikołaj Gwóźdź wrote:
> Hi,
> I'm going to work with Oracle 10g database with up to 60 mln records in one
> table. The number of tables will be in range 20 - 50. All records are small
> (about 200 bytes). There are no relations between tables. What hardware
> architecture would you recommend?
> - one multiprocessor server with a lot of RAM
> - RAC
> - grid
> - other
> Speed for both inserts and selects is important. The solution should be
> also cheap:)
>
> Regards,
> Mikolaj

Your question makes no sense as written.

RAC has to do with high availability. The number of records, tables, etc. is irrelevant.

Grid Control is a tool used for managing stand-alone and RAC database implementations and, similarly, has nothing to do with records or tables either.

What you describe is NOT a big Oracle database ... it is a very small Oracle database. And personally I'd feel comfortable hosting it on my laptop based on what you've written. Though obviously the number of simultaneously connected users and the actual usage and SLA would likely make me tend to use other hardware.

I would urge you to put together a more meaningful requirements list and then ask your question again.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)