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: Having 3-4 small databases on same server ?

Re: Having 3-4 small databases on same server ?

From: Ashish Mittal <mittalashish_at_yahoo.com>
Date: Sat, 23 Feb 2002 17:04:44 GMT
Message-ID: <MYPd8.1972$bs1.31104@sccrnsc01>


If you are running the same version of Oracle, have you considered having different schemas on the same instance?
"Mark" <mark_at_foxhillgroup.com> wrote in message news:3c77465a.17783651_at_netnews.attbi.com...
> Christian,
>
> This isn't a problem at all. We have this setup on all our servers. In
> our case we grouped the databases by application type (OLTP,
> Reporting, etc.) and put all database of a particular type on the same
> server. Our OLTP server currently has 15 instances with 4 ORACLE_HOMES
> (7.3.4, 8.0.5, 8.1.6, and 8.1.7). This is a 12 CPU box with 8 GB of
> RAM running Solaris 7.
>
> Hope this helps.
>
> Mark...
>
> On 21 Feb 2002 06:57:39 -0800, chse30_at_hotmail.com (Christian Svensson)
> wrote:
>
> >Greetings all,
> >
> >We are about to consolidate 3-4 small databases into one (Unix)
> >server. Before they reside on old Sparstation machines and we want to
> >throw those out, about time...
> >
> >Are there any special things to be aware of besides:
> >
> >- We cant upgrade Oracle on just one of the databases, we have to take
> >them all in one time. (am aware of multiple $ORACLE_HOME)
> >- When the server have to reboot, all databases are affected
> >- Careful sizing of SGA for the databases
> >- Make sure that the server can stand up with the expected user load
> >from all the databases
> >
> >Anyone know what Oracle says about this ?
> >Are there any documentation about this ?
> >
> >Thanks for any comments on this.
> >
> >Regards
> >
> >Christian
>
Received on Sat Feb 23 2002 - 11:04:44 CST

Original text of this message

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