How many instances

[maguila]

We have a server working with 5 instances but we plan to move about 15 applications currently running in access to Oracle in the same server and my question is could it be possible to make just one instance for all these application and make one user/schema for each of them, or need one instance per application?

[marist89]

The CW is to put multiple schemas into one instance. If you think you might have scalability issues, you may want to split into a couple instances.

[maguila]

Originally posted by marist89
The CW is to put multiple schemas into one instance. If you think you might have scalability issues, you may want to split into a couple instances.

Thank you

[raghud]

Unless you have lot of latch problems( I mean more locks on memory structures means heavy user activities that one set of structures can not manage) . We do not need multiple instances.

[jodie]

Another thing to think about is downtime/upgrades. I agree that having as much in one instance as possible is a great idea. Just think about the requirements for downtime, etc. Is one app 24/7 and another 9 to 5? If so, then it would be hard to do maintenance on the 9 to 5 app if the db needed to be bounced. Same goes for upgrades. If you can't upgrade them all, then you'll have to create a new instance for those that are upgraded.

Just food for thought.

Jodie

[Axr2]

Originally posted by maguila
We have a server working with 5 instances but we plan to move about 15 applications currently running in access to Oracle in the same server and my question is could it be possible to make just one instance for all these application and make one user/schema for each of them, or need one instance per application?

See
http://asktom.oracle.com/pls/ask/f?p...2029405255567,

for pros/cons. This question has been asked/addressed here a few times in the recent past. Do a search.