A Dell Inspiron 8200 laptop has 1 GB of RAM with 30 GB of disk running
Window 2000 Professional. The SGA sizes for 5 Oracle instances are:
Oracle 7.3.4.5.0 - 11 MB
Oracle 8.0.6.3.8 - 15 MB
Oracle 8.1.7.4.1 - 94 MB
Oracle 9.0.1.4.0 - 109 MB
Oracle 9.2.0.2.1 - 113 MB
While presenting, the task
Re :
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 ?
The
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
I have run/am running multiple oracle databases on a single server on
AIX/Linux/W2K/NT although not with sga's in the GB area.Just make sure you
get away with your I/O requirements
We only had seperate homes for seperate oracle versions, so all 817
databases were in one home and 8.0.5 databases
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
:
Sent by: rootSubject: Running multiple instances on
a [large] server
Title: RE: Running multiple instances on a [large] server
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
[EMAIL PROTECTED]
@singnet.com.sg cc:
Sent by: rootSubject: Running multiple
instances on a [large] server
03/11/2003 03:48
AM
We also run several instances on just about every server we have. Most, but not
all share the same Oracle_home. I only create new ones for newer versions of
Oracle, but for each database I prefer to use seperate mount points such as:
/test/system
/test/rbs
/test/temp
/prod1/system
/prod1/rbs
multiple
instances on a [large] server
Hemant
What you are considering is certainly feasible. Consider how compatible
these applications are, whether they have similar requirements in terms of
uptime. Are their performance requirements compatible? One factor to
consider is future upgrade paths of the applications. We seem to run
Hemant
Dick makes a good point about physical memory. The problem with a lot of
instances is that they all have fixed amounts of memory (except in 9i, up to
SGA_MAX_SIZE), and if one instance needs more memory you can't reallocate
unless you bounce it to add memory and maybe bounce several
To: Multiple
recipients of
list ORACLE-L [EMAIL PROTECTED]
@singnet.com.sg cc:
Sent by: rootSubject: Running
multiple
instances
:
Subject: Re[2]: Running multiple
instances on a [large] server
Title: RE: Running multiple instances on a [large] server
We run upto 22 instances on large SUN boxes... Each environment has their own oracle home, own file system, and in some cases-their own UNIX account for the environment..
One loses a little space for the multiple oracle homes
]
@singnet.com.sg cc:
Sent by: rootSubject: Running multiple
instances on a [large] server
03/11/2003 03:48
AM
Please respond
to ORACLE-L
One
RE: Running multiple instances on a [large] serverBy environment do you
mean instance? If so, couldn't you accomplish the same thing with one
oracle home on each server for each version installed? That's what we do in
our clustered environments. Each node has an oracle home for each version of
17 matches
Mail list logo