system requirement for performance testing

From: Harvinder Singh <Harvinder.Singh_at_MetraTech.com>
Date: Mon, 25 Jun 2001 15:04:32 -0700
Message-ID: <F001.00337704.20010625151706@fatcity.com>

Hi,

We r building a application and need to specify the requirements of a hardware for testing of its performance. our performace metric includes mostly insert statements........ 10 million insert to 7 tables...then we have to execute some procedures...then report.....
our main concern is insert...we can't use any bulk inserts...all inserts will be thru application insert
statements.....
Here is the brief test information........ 10 million insert now taking about 26 hrs for 127,000 accounts with this pace it will take about 40 days only(if everything go well).... for insert while we need to finish this in less than 20 days...this test is on 1 cpu single hard disk..512Mb ram......this insert is a single user activity.batch processing...... database size is estimated to be about 400G........ not much complex stored procedures....only worry is insert...... we generally use DELL machines.....we need to use NT only......

I will appreciate if u give some suggestion with ur experience....... information i need is :

1) number of hard disks ...how much capacity each....
2) how many cpu's......
3) how much RAM......

I need to explain the management for each request so kindly include the reason for each request.

Thanks
Harvinder
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Harvinder Singh
INET: Harvinder.Singh_at_MetraTech.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Jun 25 2001 - 17:04:32 CDT