On our development RAC servers we have 24 instances ... on each side, performance is okay.
Raj
-------------------------------------------------------------
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !!
-----Original Message-----
From: Stephane Paquette [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 11, 2003 9:19 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Running multiple instances on a [large] server
Hi,
On one of the 7 development box (aix 4.3.3) we have 27 instances Oracle
8172.
All using the same oracle_home.
I can't say it's the fastest response time ;-)
As for the licensing we have a mix of CPU and user licences.
Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tél. (514) 925-7187
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
-----Original Message-----
Chitale
Sent: Tuesday, March 11, 2003 3:49 AM
To: Multiple recipients of list ORACLE-L
One of the teams here is planning to run anything
from 8 to 16 database instances [no indication on
sizing yet, but gut-feel SGAs are 200MB to 1GB
and DB sizes 500MB to 40GB] on a "large" server,
something like a Sun E6800 or an equivalent
HP or Fujitsu server.
1. How many of you do run, and are comfortable running,
multiple databases on the same server, whether it is
"partitioned" or not ?
2. Do you create a seperate ORACLE_HOME for
each instance ?
3. Do you just buy the Oracle DB CPU license on the
total number of CPUs on the server ?
My positioning is
a. We might not be able to create 8 partitions but
partition such that we have a max of 2 or 3 instances
in one partition. Hopefully, I can dynamically change
CPU partitioning to reallocate CPU to another group
of instances.
b. Each instance should have it's own ORACLE_HOME.
[Disk space is not a constraint].
c. Just add up the number of CPUs on the server,
across all partitions, and buy a CPU license. Also,
a CPU license is much preferable to Named-User as some
of these databases would host Portals for 1,000+ end-users.
Hemant K Chitale
http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephane Paquette
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
*********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************1
