Path: news.easynews.com!easynews!news-xfer2.newshosting.com!news-out.nuthinbutnews.com!propagator-sterling!news-in.nuthinbutnews.com!cyclone1.gnilink.net!washdc3-snf1!washdc3-snh1.gtei.net!bstnma1-snf1.gtei.net!news.gtei.net!news2.gte.com!news.gte.com!not-for-mail
From: "Kevin Brand" <kevin.brandx@tel.gte.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Need database splitting advice
Date: Thu, 6 Jun 2002 15:31:49 -0500
Organization: GTE Laboratories Incorporated
Lines: 34
Message-ID: <adogqk$t40$1@news.gte.com>
References: <64a5ef9b.0206061002.1a2cb570@posting.google.com>
NNTP-Posting-Host: 143.91.92.241
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.3018.1300
X-MIMEOLE: Produced By Microsoft MimeOLE V5.00.3018.1300
Xref: easynews comp.databases.oracle.server:149788
X-Received-Date: Thu, 06 Jun 2002 13:28:41 MST (news.easynews.com)


Joe,

If you implement method 1, you will not be able to safely test and integrate
new versions or patches of the Oracle RDBMS.  Besides, you can never
completely control what the developers do in the development instances.

I'd go with #2.

-Kevin

"Joe Condle" <condjp@chp.edu> wrote in message
news:64a5ef9b.0206061002.1a2cb570@posting.google.com...
> I have two production databases running off one Compaq 4100.  In
> addition to the two production databases there at least one test db
> running along with the production databases. This a Peoplesoft
> installation.  There could be more tests db's running other than the
> normal two.
>
> We will be getting one more 4100 to try and split things off.  My
> question is which the two scenarios is better.
>
> 1. Dedicate one machine per production DB along with it test DB's.
> 2. Have one machine for the two production  DB's and one machine for
> test DB's.
>
> I personally lean toward number one, because I can improve performance
> of the production DB's by shutting down test DB's if I have to.
>
> Any Opinions
>
> Joe