Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Does this happen to you at work?
On 5/10/05, stephen booth <stephenbooth.uk_at_gmail.com> wrote:
>
> On 5/10/05, david wendelken <davewendelken_at_earthlink.net> wrote:
> > Short of national security concerns, why would you want the extra
> overhea=
> d of two additional database instances instead of just using three schemas
> =
> in one instance?
>
> Various reasons. The main ones are around mobility and political
> infightin=
> g.
As with all things, there is no hard and fast answer to that.
We have a number of apps with a small number of tables.
These don't get their own instance.
A number of replicated tables from 3 different apps don't get their own
instance.
( not a DW )
SAP get it's own instance for each database.
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-lReceived on Tue May 10 2005 - 16:53:08 CDT
![]() |
![]() |