Re: Advice on NT and ORACLE hardware

Steve Cocks wrote in message <74lkbg$7is_at_newstoo.ericsson.se>...
>Looking for some ballpark advice on what sort of hardware we must use for an
>ORACLE 8 Enterprise database that will inially consist of 4,000,000 records.
>Will be a mixture of text and graphics that will consume 100 G of HD.
>We will be using NT as our operating system on the database server and are
>thinking along the lines of a rack mounted RAID5 system with 2 banks of
>6x18G SCSI disks (5+hot swap).

Yup, shouldn't be a problem. Get big memory though, you'll need it.

>The system will grow in the future with the addition of 30,000,000
>documents.

You're talking from the same extrapolation of 800Gb of data or roughly thereabouts.
Hope your budget will grow too. You'll need beefy hardware for that, no matter what database or OS...

>
>Can ORACLE handle this sort of volume ?
>

Easy. You might have to take care of the indexing to make sure it's optimal for your purposes, but database-wise no probs.

>Can NT ?

Hmmmmmm, probably yes but get ready for a big hardware budget. In this size I'd be looking at UNIX straight away, NT is just not there (no pun intended!) for these big sizes. For a number of reasons I'm not gonna bore you with, they are available from somewhere else.
I have 15 million rows on a table at work with UNIX. The hardware can do queries on this in about 2 minutes, although not heaps of concurrent ones. And it is a beefy UNIX box... So don't expect OLTP performance in your queries to this database unless you can afford heaps of CPU and memory to cache the thing. Resist the temptation to put everything on the single table, it won't work in the long run.

--
Cheers
Nuno Souto
nsouto_at_acay.com.au Received on Wed Dec 09 1998 - 05:50:07 CST