DBs, Schemas and tables.
561323Feb 12 2007 — edited Feb 12 2007Hi,
I have a set of very similar applications, all of the using the exact same set of tables, running now on different instances of DBs on the same server. The data for every application needs to be kept independent from each other.
I was wondering what would be the pros and cons of moving all the applications tables into the same DB instance, but on different schemas each. Would it be worth to have every schema in a different tablespace?
These apps are not very transaction intensive, and they're running Oracle 10g, on a Dual Xeon 3ghz server with 2Gb ram. The datafiles are in two RAID 0+1 disk arrays.
Thanks in advance.