Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Instances
You may have started a major 'religious ' war...
IMHO, 1 instance with several schemas ( not databases) , given sufficient similarity between the usage of the data ( all OLTP or all DSS or Warehouse ) , is easier to manage and, with Power Unit pricing, the more you can get on one server, the better...
If the useage is different, you may want to set up separate servers with an instance on each, tuned to the specific needs...
( Mostly, more than one instance on the same server is ( again IMHO) asking for grief...)
Eric Bonnet <erbon_at_gengenp.rug.ac.be> wrote:
>Hi there,
>
>I'd like to know if it is better to have one instance holding several
>databases or several instances and several databses as well ? What are
>the benefits / drawbacks of each solution ?
>
>Thanks,
>
>Eric
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! Check out our new Unlimited Server. No Download or Time Limits! -----== Over 80,000 Newsgroups - 19 Different Servers! ==----- Received on Mon Mar 11 2002 - 11:13:04 CST