Re: Big Oracle database question

From: HansF <News.Hans_at_telus.net>
Date: Thu, 05 Jan 2006 14:41:08 GMT
Message-Id: <pan.2006.01.05.14.41.07.713884@telus.net>

On Thu, 05 Jan 2006 08:42:26 +0100, Mikolaj Gwozdz wrote:

> Dnia Wed, 04 Jan 2006 09:32:11 -0800, DA Morgan napisa(a):
>

>> I would urge you to put together a more meaningful requirements list
>> and then ask your question again.

>
> Ok, but the only requirement I can add is the speed of inserting rows into
> tables. Application should be able to insert avg. 25 records per second and
> 150 rps in peak. At this time other applications should normally read from
> the same table.
>

Again, that is not a heavy load.

A lot depends on your disk configuration (speed and distribution). And even more on how the app is designed and how good your DBA is in compensating for design deficiencies.

The only way to tell is to set up a test bed and try it. With a good Oracle DBA (consultant) at your side. For what you describe, I would start with a dual core AMD, 2GB RAM and runlevel 3 (no or remote-only GUI) Linux/Unix. Stay away from Raid5 for this (since it's write intensive), look at JBOD or Raid 1+0 and SAME (stripe and mirror everywhere).

Just make sure the redo logs are not the bottleneck (they typically will be in this type of app) and the shared pool is not the bottleneck (often a sign of poor design)

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** Top posting [replies] guarantees I won't respond. ***

Received on Thu Jan 05 2006 - 08:41:08 CST