Hi all:

I'm trying to decide on a design of a data warehouse. It will host three
large apps each
is 150-250G (including indices and aggs) and a few smaller apps. The
largest applications
are not interdependent. The data are being loaded into the tables on a
daily basis once
a day and then various reports are executed against the tables. Curently
two of the
largest apps are sharing an instance, while the third one has its own
instance. We (
me and another DBA on my team) have been debating whether to join all three
apps
into one big Data Warehouse to cut down on memory usage and the maintenance
overhead.
How do we weight the pros and cons to arrive at a decision? Any thoughts?

thank you

Gene Gurevich




Oracle LazyDBA home page