Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How many Oracle 9i Instances can I create on the P650 AIX?
Sybrand,
I totally agree with you as far as using schema's, but I just recently joined on this project, and the DBA before me decided to go with separate databases. The project has been going for 6 years and there is a lot of code that relates to only one schema. It would take thousands of hours to rewrite this code, so that is I'm stuck with multiple instances instead of multiple schema's. I have another exact server with 9 instances running and it has to be restarted once a month to clear the paging space.
Going back to you answer, so the maximum number of instances will be 2, to have good performance and avoid swapping.
Thank you for replying. Received on Wed Sep 29 2004 - 17:14:53 CDT