Re: Conversion to Oracle

Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1076051099.338093_at_yasure>...
> 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.

So now since the OLTP and DW are almost identical, they get rid of the DW so every report can be up to the second, so read consistency has to be maintained for all transactions for all day, 'cause that's how long some of those reports run and... it all gets blown off when someone runs Oracle Installer to deinstall a test system from the wrong X window.

The result is similar to how I've gotten several jobs over the years, actually. An easy act to follow.

Note that if you have, say, a SANS terabyte of usable disk (not enough, BTW), you can divvy half of it to 5 and half to 0+1, so you will have 500G available to 5 and 250G available to 0+1. Put the majority of the static data on the 5 and the volatile partition of the transactional data on the 0+1 along with redo and rollback (likely to be your heaviest OLTP usage, see your current stats - oh wait, you said another db).

Keep the separate machines and double memory.

jg

--
@home.com is bogus.
http://www.crank.net/day.html