Re: Big Oracle database question

On Wed, 04 Jan 2006 16:01:33 +0100, you wrote:

> Hi,
> I'm going to work with Oracle 10g database with up to 60 mln records in one
> table. The number of tables will be in range 20 - 50. All records are small
> (about 200 bytes). There are no relations between tables. What hardware
> architecture would you recommend?
> - one multiprocessor server with a lot of RAM
> - RAC
> - grid
> - other
> Speed for both inserts and selects is important. The solution should be
> also cheap:)
 

Up to 2G RAM, 1 AMD dual-core XP at 3200MHz, several of fastest bloody disks you can find set up in a JBOD+ASM or RAID 1+0 config. Avoid RAID5 unless you have a decent SAN/NAS with LOTS of front end RAM, otherwise your inserts will suffer.

Make sure you get the tuning and diagnostics packs so you can turn on AWR and ADDM. Set sga_max_size and pga_max_size and forget the rest of the mem sizing settings unless ADDM advises otherwise.

(It's actually a silly question as stated, because the biggest factor will be the way the app is written and how good the DBA is at compensating for poorly written apps.)

BTW - no relations between tables worries the hell out of me. Opens up all sorts of images about 'putting the intelligence into the app'. Funny thing is - apps have a typical life span of a few years, the data under the apps have a typical life span of decades. Developers are always tinkering with the apps and then managers/customers wonder why the data becomes inconsistent. [oh, we just put in a quick patch ... ooops]

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