John Yard wrote:
> I have been asked to look into converting to Oracle from
> another db system.
>
> There are 3 seperate databases , each on it's own physical machine
> ( AIX IBM ), a OLTP production system, a data warehouse - the
> data on the data warehouse being almost identical to the OLTP system,
> and a test system. Each system has about 110G of data ( on Raid 5 )
> and 4G of memory each.
>
> I am thinking about getting an upgraded production machine with
> 8G on memory to run the oltp and the data warehouse on one machine.
> Is it recommended to run as one instance or two. The OLTP and
> Data Warehousing was split off years ago - pre-1996 - in fears
> that they would comptete for memory and cpu.
>
> Is there any suggestions available or documentation available
> that would help in making this decision ?
>
> John Yard
> UCLA
Religious fervor aside ... I'd blow away the RAID 5, go with 0+1, and
try to put it all on one machine in one instance with 9i.
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Fri Feb 06 2004 - 01:05:52 CST
