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 ma
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 conse
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
Do all share the same address space or does each instance get it's own copy
of Oracle.exe and it's own 2g address space?
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, March 11, 2003 10:04 AM
> We are running 11 instances on WinNT with
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, and it
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 other
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 into
We are running 11 instances on WinNT with no problems! At one point, we had
26 instances. they are all development instances, so volumn and load are
low. but they all share one Oracle Home.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Tuesday, March 11, 2003 9
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
I can't remember the last time that I saw a server (other than WinNT)
running a single instance. My experience is that it's quite normal to run
multiple instances on a single server.
One Oracle home per version of Oracle. I'm not sure what the point of a
separate Oracle home per instance would
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 Administrat
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 we
12 matches
Mail list logo