Conversion to Oracle

From: John Yard <jyard_at_ais.ucla.edu>
Date: Thu, 05 Feb 2004 18:13:27 -0800
Message-ID: <4022F847.2080905@ais.ucla.edu>

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 Received on Thu Feb 05 2004 - 20:13:27 CST