Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Design: How many instances should we have?
We keep three "production" instances: A is for transaction processing applications (many apps, many users), B is for "warehouse" apps (few apps, few users but large queries), and C is for Designer/2000. I often wonder about having separate instances for each warehouse since each one often requires large loads but the demand is unpredictable and we can usually schedule loads so that they don't interfere with one another.
Richard
Don wrote:
>
> In an environment with many stand-alone applications running against
> "non-shared" Oracle databases, what are some guidelines for creating
> new, separate "instances" of Oracle?
>
Received on Fri Aug 01 1997 - 00:00:00 CDT