QUESTION POSED ON: 20 July 2007
I'm a DBA at an Oracle software development company. I'm hoping you can help us figure out a solution to our dilemma.
We have multiple Oracle 9i instances (9i is still used to ensure software backward-compatibility for our customers) running on Sun equipment. One for development, one for quality assurance, one for final production and another for internal software (help desk, time and attendance, etc.).
Inside each instance is typically one schema for each supported base version of our product in two different languages as well as one schema for each of our clients' custom development.
As of this writing we have 81 schemas in our development instance! While the schemas are usually relatively small data-wise, this arrangement makes for a SYSTEM tablespace approaching 20 GB! Of course, this is extremely inefficient for the data dictionary to be so huge. Performance issues do indeed exist.
We use scripts to perform many functions that rely on all development schemas being in the development instance, QA in the QA instance, and so on.
We're soon to be contemplating the replacement of our main server which handles all of these instances. I've put forth the idea of going to a RAC system to help alleviate the bottlenecks and downtime concerns, but the reality of a 20GB data dictionary is still daunting.
What best practices exist for such an environment? Recommendations, please?! Thanks!
|
