Re: Any Info Would Help...

hilljm1974_at_gmail.com wrote:
> Hello,
>
> Currently the company I work for is running an Oracle 10gR2 SE1
> database server (using Linux OS) for an inhouse developed ad-hoc
> querying system adding roughly 1 million records / year.
>
> They want to scale it up to handle 5 - 10 million records / year.
>
> While testing to see if the current system design can handle this, I
> have found a lot of performance degradation in the response time from
> Oracle. They have agreed to change the hardware platform, but we are
> still limited to using SE1 only.
>
> Anyone have any suggestions on hardware selection to handle this kind
> of data load with fast query response times (fast meaning under 2
> minutes)?
>
> Any advise on how to arrange tablespace, etc. to tune this system would
> be a great benefit too, since SE1 does not give you any real tools
> (partitioning, bit indexing, diagnostic pack, tuning pack, etc).
>
> Thanks in advance!
>
> Jeremy

Based on what you posted I wouldn't spend $1 on new hardware.

I can insert 100,000 records/second on my IBM ThinkPad with its miserable 7500 RPM drive.

Far more information is required to make a recommendation.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org