Re: Creating a oracle production environment.

It's one instance=one database.

But you can have multiple instances (multiple databases) running simultaneously on the same server. I would be willing to bet that 96MB is way too small though. (Remember Oracle is an oinker and an old rule of thumb is that the sum of the sga sizes should not exceed 1/3 your RAM.) If I were you, I would consider a separate server for performance and safety. The other rule of thumb I like to remember is the the purpose of any test environment--which includes development--is to be destroyed by testing. I don't like test and production on the same machine.

In article <6ocg1v$esq$1_at_nnrp1.dejanews.com>,   rune.slinning_at_bigfoot.com wrote:
> Hi All,
>
> We are currently running oracle 7.3.3 on a NT4.0 box (pentium pro 200 MHz, 96
> MB ram, 8 GB HD). So far we have only needed a developer environment with one
> database instance and one database.
>
> Soon the users will start hammering the system, so we need a production
> environment. Do any have a guideline on how to create a production environment
> from the developer environment?
>
> My understanding is that I need at least one instance per database. Is this
> correct or can I create several databases on the same instance with the
> "create database" sql-statement?
>
> Thanks,
> Rune
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Jul 13 1998 - 15:04:11 CDT