Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DW and change control: recommendations?

Re: DW and change control: recommendations?

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Thu, 22 Jul 1999 15:57:26 -0700
Message-ID: <3797A1D6.E0867D0@us.oracle.com>


David

Most of the DW sites I've seen do use a significantly smaller DEV database on a separate instance. If by chance you're on 8i, the tuning can be reasonably similar if you use stored outlines produced from Production once it's there.

HTH. Pete

David Sisk wrote:

> A fairly large (200-300 Gb) data warehouse is in consideration by my
> company. One area of logistics consideration is the change control
> methodology. Typically, I would recommend a development instance on one
> box, and a production instance on a different box (at least). I'm curious
> as to what other organizations with a large or very large data warehouse do
> in terms of change control and segregation between DEV and PROD,
> particularly prior to implementation. One thought would be to still run DEV
> and PROD on seperate machines, but to use a significantly smaller box for
> DEV and only include a subset of data for development purposes. This can
> cause some expected results in PROD though, due to differences in volumes of
> data and differences in data distribution (particularly where tuning is
> concerned).
>
> If anyone has any stories they'd like to share or suggestions, I'm all ears.
> If you would be so kind, please email as well as posting.
>
> Regards,
>
> --
> David C. Sisk
> The Unofficial ORACLE on NT site
> http://www.ipass.net/~davesisk/oont.htm

--
Regards

Pete


Received on Thu Jul 22 1999 - 17:57:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US