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