I am a veteran Oracle DBA with a strategic question. Our business unit has a Unix server with five instances -- running a variety of small apps, a small data warehouse and a few repositories. Having five instances wastes resources and duplicates administrative tasks, so I'd like to realign the instances. My question is: What's an appropriate disposition and why?
Here are some givens:
Some options I'm considering are:
I'm not looking for the "book" answer from Oracle, I'm looking for practical, pragmatic reasoning.
It has been the IT business climate these days to squeeze more out of their systems in an effort to cut costs. One of the things that a DBA may consider is to consolidate instances. The first thing that I should tell you is that many experts advocate never running multiple applications against the same Oracle instance. Their advice is to just run multiple instances on the same server instead. While I try to follow this line of reasoning, there are business considerations that often dictate against this advice.
So what do you need to consider when combining applications into one Oracle instance?
1. Only one instance to monitor on one server. This can greatly reduce your administration overhead as well as reduce your hardware costs.
2. Performance tuning becomes more difficult. You are sharing resources among applications so each application's performance now affects another application's performance. One application with a terrible SQL statement can impact other applications. When you look at the buffer cache, is it one or more applications that are causing a poor performing buffer cache?
3. One of the biggest headaches concerns your database version and application certification against that version. This is especially important with third-party applications. You may have purchased a third-party application that is only certified on Oracle9i. But other third-party vendors will only certify their product on Oracle8i. So you can't upgrade the instance to support one product because the other products aren't ready for the new version. So what do you do? If you have many third-party applications, you will find that one of your application's vendor is keeping you on an older release. Is that fair to the other application users?
4. Business rules of your application can cause some problems. One application needs to be up 24x7, but the other applications don't care. This can force you into a backup strategy or do other things to the instance that you wouldn't be constrained to otherwise.
These are just a few of the things that come to mind. But it should start you down the road of determining in consolidation of your Oracle instances. Personally, I like to keep one instance per application. But there are times that I have disregarded that rule of thumb.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.