Re: How many Oracle 9i Instances can I create on the P650 AIX?

"DBA" <marcelmix_at_yahoo.com> wrote in message news:3607af43.0409291414.1b324751_at_posting.google.com...
> 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.

As you stated you could ran about ten intances, depending size of them. Or maybe we could say 200 users with that hardware. You migth need more RAM with ten instances.

Obviously you should upgrade Oracle Received on Thu Sep 30 2004 - 02:07:30 CDT