Overhead of multiple instance vs. multiple schema [message #57535] |
Fri, 20 June 2003 13:20 |
Steve Wilson
Messages: 1 Registered: June 2003
|
Junior Member |
|
|
Any insight or referal to a publication that would describe the advantages and dissadvantages of segregating an enterprise application into multiple instances on a server rather than creating multiple schemas within a single instance?
|
|
|
|
Re: Overhead of multiple instance vs. multiple schema [message #57546 is a reply to message #57537] |
Sat, 21 June 2003 14:56 |
pwl
Messages: 22 Registered: May 2000
|
Junior Member |
|
|
Tom has it right 100%.
We have one system of 5 seperate instances, then
linked by Database Links, on 1 single machine.
We have trouble getting the tuning right because of
the interconnections and no SGA is really big enough
on its own.
BUT the business says it cannot afford to pay for a
change to the system in order that it would be a
single instance with 5 schemas.
Of note is that there are 5 auditing schema within
these. Now reducing that to 1 must surely be a win
all round.
So, dig your heels in - its a single instance.
Otherwise you will be running just to keep the system
going.
good luck
pwl
|
|
|