SATA drive ?

[Net Llama!]

On Mon, 27 Sep 2004, Vu Pham wrote:
> > -----Original Message-----
> > From: linux-users-bounces at linux-sxs.org
> > [mailto:linux-users-bounces at linux-sxs.org] On Behalf Of Net Llama!
> > Sent: Monday, September 27, 2004 8:34 AM
> > To: Linux tips and tricks
> > Subject: Re: SATA drive ?
> >
> > On Mon, 27 Sep 2004, Vu Pham wrote:
> > > Good morning,
> > >
> > > I am going to install a Linux box with Oracle. This is not a
> > > production system and I would like to look for some not
> > very expensive
> > > parts, but the system is not so slow, too :-)
> > >
> > > I saw a recent thread on our forum about AMD 64. The article is
> > > interesting I think I will go for that CPU.
> > >
> > > How about the hard drive ? I guess the SATA is good enough.
> > Which SATA
> > > drive is a fast one now ?
> >
> > The performance of an oracle database is impacted by a lot
> > more than the disk speed.  In fact, i'd say that the amount
> > of RAM coupled with tuning of the database would impact
> > performance more than the speed of your disks unless you're
> > doing something that is very write intensive to the database.
> >
>
> Thanks for the suggestion. This system is a pilot system, its database is
> small ( no more than 10,000 records ) and no more than 5 users accessing to
> the system at same time. How much memory is reasonable in this case ?

10k records of what kinda of data?  Is each record 1k, 1M or 1G in size?
What are you doing with the records?  Is this just simple selects, inserts
& updates, or are you doing fancier things with Oracle specific
functionality?  How many transactions per second or per minute, and at
peak usage?

Also, the amount of RAM in the box is irrelevant if you don't tune the
database to take advantage of it to coincide with how you're using the
database.

-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Lonni J Friedman                                netllama at linux-sxs.org
Linux Step-by-step & TyGeMo                  http://netllama.ipfox.com