Thanks for the Reply.
Having two DBs in two different machine, what will the performance difference instead of having it in one machine itself?
Mainly my question is, when DBs are in different machine or in same machine , How the performance differs, if we dont consider security
With the databases on separate machines you obviously introduce some degree of extra work to navigate the network if/when traffic has to pass between them
You haven't yet made the case that 2 databases are preferable to 1.
and you haven't made the case to support the decision to go with an Oracle release that is now on 'sustaining' support when there are two major releases more current.
>Mainly my question is, when DBs are in different machine or in same machine , How the performance differs,
Does data need to be exchanged between the two databases?
If yes, then two machines could slow down the application.
if no, then application might be faster (or not).
It depends on external factors.