Any Info Would Help...

From: <hilljm1974_at_gmail.com>
Date: 12 Jan 2007 12:08:01 -0800
Message-ID: <1168632481.810122.210380@s34g2000cwa.googlegroups.com>

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 Received on Fri Jan 12 2007 - 14:08:01 CST