RE: 34 databases to 1 database

Four disks is not bad as long you end up with four spindles dedicated to your database. If not , then raid-5 will be better choice than raid 0+1 since you will end up having three spindles rather than two. You got plenty of memory to allocate to the SGA to avoid going to the disks.  

Regards  

Waleed

-----Original Message-----
From: Webber Valerie H [mailto:Valerie.H.Webber_at_irs.gov] Sent: Wednesday, September 27, 2000 4:26 PM To: Multiple recipients of list ORACLE-L Subject: 34 databases to 1 database

I am working on a new project to take 34 Informix (approx. 5G each;1 is 13G) that currently run on 5 UNIX Pyramids and convert to 1 Oracle database (8.1.6) on a SUN E10K.

Does anyone know of any issues to watch out for or any potential problem of having 1 database instance on Oracle and 34 schemas to reflect the current system. Does anyone know of a better solution? References to MetaLink/TechNet, etc welcomed.

The SUN E10K will have 8G of memory, 8 CPUs but only 4 18G disks (I know its a nightmare with only 4 disks. Obviously a ridiculous decision made before I joined the team...)

Thanks in advance!
Val
Valerie H. Webber
Management Systems Designers, Inc
Database Administrator
Valerie.H.Webber_at_irs.gov Received on Wed Sep 27 2000 - 15:14:30 CDT