Re: Data Warehouse allocation to Oracle instances

From: Martin Hepworth <maxsec_at_totalise.co.uk>
Date: Wed, 09 Feb 2000 09:10:59 +0000
Message-ID: <38A12F23.414B9EB5@totalise.co.uk>

daveball28_at_my-deja.com wrote:
>
> We have numerous decision support databases that we would like to pull
> together into a data warehouse. Most databases are currently in thier
> own Oracle V8 instance, but all on the same E10K.
>
> I'm new to Oracle. Does the instance assignments matter? Can we do
> cross-instance joins? Do we have a data warehouse if all databases are
> on the same box or should we move them to the same instance? Why/why
> not?
>
> The box is used for many OLTP databases also although the instance
> controls the parameters so I don't know if this matters, but am
> concerned about CPU contention.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Dave
Theres an excellant book "Oracle 8i Data Warehousing" ISBN 1555582052 that should help.

If you've got an E10K then you should look at partitioning it up so the DW doesn't eat into the OLTP space. A true DW has a separate DB for the data so it doesn't impact on the live systems. Also see Ralf Kimballs books.

martin Received on Wed Feb 09 2000 - 03:10:59 CST