Data Warehouse allocation to Oracle instances

From: <daveball28_at_my-deja.com>
Date: Tue, 08 Feb 2000 22:48:30 GMT
Message-ID: <87q6fs$83m$1@nnrp1.deja.com>

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. Received on Tue Feb 08 2000 - 16:48:30 CST