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" <ORACLE-L_at_fatcity.com>
Sent: Tuesday, March 11, 2003 10:04 AM
> 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:19 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
> 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 be.
>
> On the licensing issue --- that's Oracle's call. We have a site license
so
> it's not an issue for me.
>
>
>
>
>
> Hemant K Chitale
>
> <hkchital To: Multiple
recipients
> of list ORACLE-L <ORACLE-L_at_fatcity.com>
> @singnet.com.sg> cc:
>
> Sent by: root Subject: Running multiple
> instances on a [large] server
>
>
>
>
> 03/11/2003 03:48
>
> AM
>
> Please respond
>
> to 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: hkchital_at_singnet.com.sg
>
> 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: ListGuru_at_fatcity.com (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: Thomas Day
> INET: tday6_at_csc.com
>
> 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: ListGuru_at_fatcity.com (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: Mercadante, Thomas F
> INET: NDATFM_at_labor.state.ny.us
>
> 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: ListGuru_at_fatcity.com (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: Chuck Hamilton
INET: chuckh_at_softhome.net
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: ListGuru_at_fatcity.com (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).
Received on Tue Mar 11 2003 - 12:31:41 CST
