Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: multi oracle instances in one machine
> I would suggest using a single database with multiple schemas. That way,
> you conserve one machine resources. Unless this is actually the same app
> for production use, test use, and development use. If that's the case, then
> I'd suggest three seperate databases.
I agree. I have three instances of a single product one a server and would never consider putting them into a single instance. One is production, one pre-production testing, the third for development.
In each case the tuning needs are different. I don't want to give the same resources to a development instance where there are just a few users (developers) as I give to a production database being pounded by hundreds.
Daniel A. Morgan Received on Mon Jan 04 1999 - 14:08:50 CST
![]() |
![]() |