One vs many databases

Hi Gang,

I'm looking at submitting a business case to management that will justify changing from our current structure of many oracle databases to one big database. We currently run many separate databases (financial, sales, purchases etc...) all based on functional areas. These are all inhouse written systems. My problem with having all these instances is with trying to link data together. We need to have realtime data shared amonst the systems. Dblinks are quite slow and although materialized views have lots to offer they consume a fair amount of overhead.

Anyway, I've done some web searches looking for the pros and cons of many instances vs. one instance and have yet to find a good whitepaper on this subject. I did read through the long (70 or so posts) when someone said they were going to install 50 instances on one host, but it didn't really answer the question.

Thanks,
-John Received on Fri Jan 03 2003 - 06:37:42 CST