Tags: aix, create, database, encounter, instances, loosing, mysql, oracle, p650, performance, plan, serverwithout, sql
How many Oracle 9i Instances can I create on the P650 AIX?
6,683 words with 7 Comments; publish: Fri, 30 May 2008 11:58:00 GMT; (25062.50, « »)
I'm trying to plan how many instances can I create on the P650 Server
without loosing great deal of performance and encounter a lot of
swapping:
Server Specs:
OS: AIX 5.1
Nr of CPUs: 4
Memory: 4GB
Virtual Memory: 8GB
Disk Space: 400GB
Database Specs:
Oracle 9i (9.2.0.1)
Max user: 50
Concurrent users: 20 - 30
The size of an instance around: 4GB
The size of SGA: 500 - 600 MB
Please advise.
Thank you
Marcel
http://oracle.itags.org/q_oracle_98796.html
All Comments
Leave a comment...
- 7 Comments
- On 29 Sep 2004 08:52:05 -0700, marcelmix.oracle.itags.org.yahoo.com (DBA) wrote:
>I'm trying to plan how many instances can I create on the P650 Server
>without loosing great deal of performance and encounter a lot of
>swapping:
>Server Specs:
>OS: AIX 5.1
>Nr of CPUs: 4
>Memory: 4GB
>Virtual Memory: 8GB
>Disk Space: 400GB
>Database Specs:
>Oracle 9i (9.2.0.1)
>Max user: 50
>Concurrent users: 20 - 30
>The size of an instance around: 4GB
>The size of SGA: 500 - 600 MB
>Please advise.
>Thank you
>Marcel
Please be aware a database in other products equates to a schema
within a database in Oracle. You really shouldn't be creating
'databases' If you insist on doing so the correct answer would be 2,
based on the SGA you are specifying.
Sybrand Bakker, Senior Oracle DBA
#1; Fri, 30 May 2008 12:00:00 GMT
- Sybrand Bakker <gooiditweg.oracle.itags.org.sybrandb.verwijderdit.demon.nl> wrote in message news:<2dsll0haovv77716b7borhlunmb4jgh64l.oracle.itags.org.4ax.com>. ..
> On 29 Sep 2004 08:52:05 -0700, marcelmix.oracle.itags.org.yahoo.com (DBA) wrote:
>
> Please be aware a database in other products equates to a schema
> within a database in Oracle. You really shouldn't be creating
> 'databases' If you insist on doing so the correct answer would be 2,
> based on the SGA you are specifying.
Well, Oracle will let you create/install many instances, using many
versions (I have systems with 7.3.4, 8.0.5, 8.1.7, and 9.2.0.4 all
together), however you must look at your applications and user load to
determine how many the system will support. How you layout your
storage will be a big factor, and you don't have a bunch of memory to
work with either. I try and have 8GB per instance of Oracle on my
systems that run more than 1 instance. And all my storage is SAN
attached with dedicated volumes for each instance. You will likely be
doing a ton of SGA tuning with this config and having a 2nd instance
makes this a bit more tedious.
-chuc
#2; Fri, 30 May 2008 12:01:00 GMT
- 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.
#3; Fri, 30 May 2008 12:02:00 GMT
- On 29 Sep 2004 14:46:30 -0700, rhugga.oracle.itags.org.yahoo.com (Keg) wrote:
>I try and have 8GB per instance of Oracle on my
>systems that run more than 1 instance
8G per instance is usually waaaayyyyyyyy too much and points to
non-maintained systems with untuned sql-statements and not using bind
variables.
Sybrand Bakker, Senior Oracle DBA
#4; Fri, 30 May 2008 12:03:00 GMT
- DBA wrote:
> I'm trying to plan how many instances can I create on the P650 Server
> without loosing great deal of performance and encounter a lot of
> swapping:
> Server Specs:
> OS: AIX 5.1
> Nr of CPUs: 4
> Memory: 4GB
> Virtual Memory: 8GB
> Disk Space: 400GB
> Database Specs:
> Oracle 9i (9.2.0.1)
> Max user: 50
> Concurrent users: 20 - 30
> The size of an instance around: 4GB
> The size of SGA: 500 - 600 MB
> Please advise.
> Thank you
> Marcel
You are asking the wrong question so any integer answer is meaningless.
Why are you installing 9.2.0.1? At a minimum you should be installing
9.2.0.5.
Why do you think you need more than one instance?
Daniel A. Morgan
University of Washington
damorgan.oracle.itags.org.x.washington.edu
(replace 'x' with 'u' to respond)
#5; Fri, 30 May 2008 12:04:00 GMT
- "DBA" <marcelmix.oracle.itags.org.yahoo.com> wrote in message
news:3607af43.0409291414.1b324751.oracle.itags.org.posting.google.c om...
> 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
#6; Fri, 30 May 2008 12:05:00 GMT
- On 2004-09-29, Sybrand Bakker <sybrandb.oracle.itags.org.hccnet.nl> wrote:
> On 29 Sep 2004 14:46:30 -0700, rhugga.oracle.itags.org.yahoo.com (Keg) wrote:
>
> 8G per instance is usually waaaayyyyyyyy too much and points to
You're assuming that's all just for the SGA. Depending on the number
of client connections you expect to support, much of that could be eaten up
by dedicated server processes.
> non-maintained systems with untuned sql-statements and not using bind
> variables.
[deletia]
Negligence will never equal intent, no matter how you
attempt to distort reality to do so. This is what separates |||
the real butchers from average Joes (or Fritzes) caught up in / | \
events not in their control.
#7; Fri, 30 May 2008 12:06:00 GMT