Re: Oracle and Server Sizing!

Is your application going to be well behaved? (e.g. use bind variables and eliminate reparsing) If so then the CPU requirements go down; if not then you are going to need a lot of CPU. Also you will have to figure out how many disk IO/s per second you are going to have at peak and plan to easily handle that. So if you think you are going to have 3000 IO's per second then your disk system and controllers need to be able to handle well above 3000 IO's per second. If the typical disk can handle 60 IO's per second then you would need a minimum of 50 disks.

This should give you some idea of where to start. Jim
"Suman Saraf" <suman_at_hss.hns.com> wrote in message news:Pine.LNX.4.10.10012091816470.9209-100000_at_vckumar.hss.hns.com...
> Hi All,
>
> I need your help with Oracle for a particular project of mine. We have a
> telecom application where we need to store 1.5 million records of 10k
 each.
>
> The records are in a single table which has a particular primary key.
>
> The transactions are evenly divided between full record selects and
 updates
> (based on the primary key only) and we have to achieve 3000 transactions
> per second.
>
> Could someone suggest a typical Oracle configuration which can handle such
> throughput and at the same time provide very high reliability.
> We are open to cluster based solutions also.
>
> I would appreciate inputs on :
>
> 1. Oracle Products
> 2. Hardware Configuration(servers/disks etc)
> 3. Any special tuning procedures
>
> which would help us achieve this goal!
>
> Any inputs will be highly appreciated! It would be great if someone who
> has already deployed Oracle in such scenarios would like to share his
> experience.
>
>
> Best Regards,
> Suman
>
> PS: Please Cc: the replies to ssaraf_at_hss.hns.com.
>
Received on Sat Dec 09 2000 - 10:00:11 CST